Url with special characters is not accepted

[llaprosper]

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

[iabarraganc]

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

==========

[iabarraganc]

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

[llaprosper · Accepted solution]

This works:

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

[llaprosper]

Nope, it doesn't work