How open External Records using Power BI hyperlinks

[MYDATASTORY]

Hi,

I have an external system in which I am getting all my data, this third party system feeds the data to SQL tables. 

for example, using below dummy https and I would like to open this dummy record:  875847548HFGS4546963CVCXDummyData 

Please note below link is a dummy and has no real-life value purposely for asking help on this channel 

https://-----/#-------/GUID/875847548HFGS4546963CVCXDummyData 

I have done this previously but can't recall the steps, but I remember copying some part of https to and adding this to SQL table i.e Country table which has id, then connect this table to Power BI and when user click this hyperlink it will open that particular record on an external system.

Thanks in advance.

[Icey]

Hi @MYDATASTORY ,

Are those mentioned above the cause of your problem?

Best Regards,

Icey

[AllisonKennedy]

Have you set data categorization to URL?

[amitchandak]

@MYDATASTORY , Not very clear, refer

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables

https://stackoverflow.com/questions/61871952/webservice-to-open-external-program-when-clicking-link-...

https://www.youtube.com/watch?v=Wz2aD0XvkUk

Append and create link url like

new column = "http://abc.com?abc=" & [Column1]