Forum Discussion
Hyperlink to underlying CRM record
Hi, I have a requirement within a dashboard table to create a clickable hyperlink to the underlying record in MS Dynamics, the Dashboard uses the Direct Query method.
I have deduced from considerable googling that it should be a case of creating a custom column and changing the column type to URL, however there seems to be contradicting advice as to whether this is possible with DirectQuery.
I have tried to following various different suggestions including this one below:
Uusing the below syntax I get a “Token Eof expected” error. If I remove the colon after the https the error clears and I can click on OK. However I then get a “Expression.SyntaxError: Token Right Paren expected” error.
https://mycompany.dynamics.com/main.aspx?app=d365default&forceUCI=1&pagetype=entityrecord&etn=kln_quoteinformation&id=” & myfield_name &”
Any help would be greatly appreciated.
Thanks.
Managed to get this working and the correct syntax is:
= Table.AddColumn(dbo_kln_quoteinformation, "QuoteURL", each "https://mycompany.dynamics.com/main.aspx?app=d365default&forceUCI=1&pagetype=entityrecord&etn=myfield&id=" & [myfield] &"")
3 Replies
- parry2k
Super User
IanHallett what is the data type of Incident ID column that you are trying to concatenate in the URL?
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Hi,
I’ve actually adapted the syntax in the screenshot to the below where MyField is a text string such as this: a9c380c4-458a-ec11-93b0-6045bd8cd385
Thanks.
Managed to get this working and the correct syntax is:
= Table.AddColumn(dbo_kln_quoteinformation, "QuoteURL", each "https://mycompany.dynamics.com/main.aspx?app=d365default&forceUCI=1&pagetype=entityrecord&etn=myfield&id=" & [myfield] &"")
