cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

How to Hyperlink Power BI Report to Dynamic 365 CRM Record

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.

2 REPLIES 2
Highlighted
Super User VII
Super User VII

Re: How to Hyperlink Power BI Report to Dynamic 365 CRM Record

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper IV
Helper IV

Re: How to Hyperlink Power BI Report to Dynamic 365 CRM Record

@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/

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors