Unable to parse the apostrophe symbol

[SaiPriyaEleti]

Hi,

I have a report whose data source is ADX Function and load method is DirectQuery. Iam using the concept of parameter binding.

So I have a parameter named metadata, Iam trying to pass this parameter to the ADX Function. To retrieve multiple site data if the user selects multiple sites, I've written a code for it.(code below)

let
vsite2=
if Type.Is(Value.Type(metadata),List.Type) then

let
AddSingleQuotes = List.Transform(metadata,each """ & _ & """),

DelimitedList = Text.Combine(AddSingleQuotes,",")
in
DelimitedList
else
""" & metadata & """,

Source = AzureDataExplorer.Contents("adxclustername", "dbname", "Functionsite(dynamic(&vsite2&))", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null]),
#"Duplicated Column" = Table.DuplicateColumn(Source, "Timestamp_datetime", "Timestamp_datetime - Copy"),
#"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"Timestamp_datetime - Copy", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Timestamp_datetime - Copy", "Date Coloumn"}})
in
#"Renamed Columns"

The issue is : When I have an apostrophe symbol in the site name, it is not able to parse and this is the error Iam getting:

please help.

Thanks In Advance,

Sai Priya.

[amitchandak]

@SaiPriyaEleti , use the url encode in place of that

https://www.w3schools.com/html/html_entities.asp

Also, refer this method

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...