How to Hyperlink Power BI Report to Dynamic 365 CRM Record

[MYDATASTORY]

Hi Everyone,

Please advise how to hyperlink the Power BI report/individual record to Dynamic 365  record (I have GUI as Primary key(Globally Unique identifier)). I have a  Power BI report which has a table and it has it Primary Key which is GUI from  Dyanamic 365 and I would like when user wants to view more data they can follow the hyperlink to the actual record in Dynamic 365. Thanks in advance.

[parry2k]

@MYDATASTORY create a column with url in your table and then on modelling tab, change date category for this column to Web url.

When you drop this column in table visual, it will show a clickable url.

[MYDATASTORY]

@parry2k  Thanks for the response I had tried this before which is fine, but the next step is how to get the actual CRM URL from Dynamic 365 and dynamically change when the user clicks the Power BI report. I was trying to follow below link  but I am unable to find    /viewer/drillopen.aspx?ID={” & Opportunities[OpportunityId] & “}&LogicalName=opportunity”

from  below url which he has given as sample 

Opportunity Link = “https://yourorganization.crm.dynamics.com/CRMReports/    (I can not find the other bits from CRM)

https://crmtipoftheday.com/782/hyperlink-from-powerbi-to-dynamics365/