Tip #782: Hyperlink from PowerBI to Dynamics 365

Have you ever wished you could link from a table row in Power BI to over to Dynamics CRM – allowing users to filter and view the records in a grid or matrix in PowerBI and when they want more detail, they can click to open the corresponding record CRM?

Wish granted!

To begin: ensure you’ve added the entity’s primary id (GUID) to the dataset for the entity you want to build the hyperlink for.

Add a new column in the entity using this formula as a template:

Opportunity Link = “https://yourorganization.crm.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={” & Opportunities[OpportunityId] & “}&LogicalName=opportunity

tip-of-the-day-hyperlink-from-powerbi-to-crm

  1. Give the link a name (in this case it’s to the opportunity table, so I’ve named it ‘Opportunity Link’)
  2. Change the first part of the URL (up to the /CRMReports portion) to match the URL for your CRM organization.
  3. Opportunities[opportunityid] is the reference to the recordid field (guid) in the “opportunities” table
  4. Replace ‘opportunity‘ with the schema (logical) name of the entity from CRM.
  5. Select this new column and on the ‘Modeling’ tab, change the ‘Data Category’ to Web URL.
  6. Bonus tip thanks to @CRMChartGuy – On the Formatting tab of the entity, expand the ‘Values’ area and change the ‘URL icon’ setting to “On” – This will change the URL to an icon that looks like a couple of links of a chain. – nice!

Enjoy!

6 thoughts on “Tip #782: Hyperlink from PowerBI to Dynamics 365

  1. […] Sewell talks about how to link to CRM from a Power BI report or dashboard. We covered this in Tip 782 on CRM Tip of the […]

  2. Adrian Stopp says:

    Thank you for this tip!
    Would you guys know if there’s a way of doing the opposite, adding a PowerBI link in the CRM, to the corresponding record?

    Let’s say I have built a PowerBI report where I filter on “Account”, and when I am in CRM on that account I would like a link to my PowerBI report that would then be already filtered on this specific account.

    Maybe much more tricky than above post, but haven’t found any discussions regarding this on any forum.

    Thank you

  3. Kelly Turdanes says:

    Hi,

    Is it possible to implement in Power BI online? I can’t seem to find how to do this from online.

    Thanks.

  4. Phoebe says:

    Hi,

    How do I go and do the first step:
    ensure you’ve added the entity’s primary id (GUID) to the dataset for the entity you want to build the hyperlink for.

    I am very new to Power BI and now yet familiar how most of the things needs to be done.

    Thanks so much

Leave a Reply

Your email address will not be published. Required fields are marked *