topic Re: Url with special characters is not accepted in DAX Commands and Tips

Url with special characters is not accepted

llaprosper — Thu, 05 May 2022 10:19:34 GMT

Hi,

can you tell me how to pass the following URL with {}?

Hyperlink = IF (table[xxxxxxxxxxxxx]<>","https://Server/wm/app-ServiceDesk/search-page/093f9348-369c/filter/248dd595-01be-6d6e-65f7?view-options={"objectId":"2b1d-8da2e737ee4","dialogId":"&Ticketing[UsedInTypeTicket]&","archived":"0","type":"Ticket","viewType":"edit"}

view-options={"objectId":"dece4bc1-a36a-cf67-2b1d-08da2e737ee4","dialogId":"&Ticketing[UsedInTypeSPSActivityTypeServiceRequest]&","archived":"0","type":"SPSActivityTypeServiceRequest","viewType":"edit"}")

Powerbi somehow does not want to accept these sections
How can I mark that the everything is an URL?

Thanks a lot

Re: Url with special characters is not accepted

iabarraganc — Fri, 06 May 2022 15:37:46 GMT

Hi llaprosper
Tries to replace the double quotation mark with three double quotation marks.
" --> """

Re: Url with special characters is not accepted

llaprosper — Tue, 10 May 2022 11:40:11 GMT

Nope, it doesn't work

Re: Url with special characters is not accepted

iabarraganc — Wed, 18 May 2022 17:10:36 GMT

Hi llaprosper

Look this

This is dax formule

==============

test =
VAR doble_quote = TRIM ( " "" " )
VAR url_start = "https://webserver/" & doble_quote & "[parameter]" & doble_quote
RETURN
url_start

==========

Re: Url with special characters is not accepted

llaprosper — Tue, 24 May 2022 13:37:12 GMT

This works:

"https://Server/50984803-48ff-e611-e282-7824af3d4067/nofilter/?view-options={""archived"":""0"",""objectId"":"""&Ticketing[UsedInType]&""",""type"":""Type"",""viewType"":""preview""}"