Power BI with Dynamics 365

Anonymous · ‎03-09-2020

I'm searching for information on a specific topic, and unfortunately I'm unable to find anything.
Hence, I'm turning my heads towards you, hoping you can point me in the right direction.

I have a Power BI report, which is published to the Power BI Service. Next, I'm embedding visuals from this report in Dynamics 365 using the built-in functionality.
This works fine.
What I'm trying to accomplish, and I'm not sure if it's possible, is to use the Power BI drill-through functionality and drill into the Dynamics 365 lists and forms.
For example, clicking a Customer Account Number on the Power BI report, this should open the Customer Form in Dynamics 365.

Does anyone in this group has some pointers which I try?
Any help is much appreciated.

Greg_Deckler · ‎03-09-2020

Well, if you can come up with the format of the URL you can flag a column in Power BI as a URL and then it is clickable.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...