cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
dkgibbs
Frequent Visitor

Pass Record URL from Dynamics 365 as Filtering Parameter in Embedded Power BI Report

I have a client that would like us to embed a power bi report onto the entity form in Dynamics 365 that displays data about that particular record. My immediate thought was that I could use the URL as a parameter because the GUID is listed in it.

 

For example:

The report is on the account main form in Dynamics. When the user selects an account record from their view, the form opens and they see their various fields, but they would also the power bi report now too. The report needs to filter the data in it to only display data for the record that the user is currently on. The url for the page would be sampleurl.crm.dynamics.com/main.aspx?appid=6a5511f3-aef1-e911-a812-000d3a579c97etc. The guid in the URL is 6a5511f3-aef1-e911-a812-000d3a579c97, and I want to be able to filter the report based on the guid that is in the URL without the end user needing to make any selections.

 

How do I go about doing this? I am not new to Power BI, but I have only recently begun to learn more advanced things. I am also open to other solutions on how to dynamically filter the report within the webpage that doesn't utilize the page URL.

7 REPLIES 7
martinbell
New Member

Did you ever work out how to do this.  i am trying to do similar

My apologies for a late response - I was out on maternity leave. No, I did not get it worked out unfortunately.

Hi, I have a similar requirement..Did you manage to figure out how to do it?

 

Thanks

dkgibbs
Frequent Visitor

No, I have not yet. I still would like to figure it out though.

v-henryk-mstf
Community Support
Community Support

Hi @dkgibbs ,

 

Creating a custom parameter is a good choice. You can use any attribute of the form to build a filter expression. The official document has related detailed introduction.

 

But you can also try other alternatives, such as below:

How to Embed a Power BI Report on Dynamics 365 CE Forms | Stoneridge Software

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-henryk-mstf

 

Thank you, but I do know how to embed the report into the form already. The problem that I am tryingt to solve is to have that report display only information that is relevant to the record that is currently up. In other words, I am trying to replace the user needing to select the account from a list of filters in the report and have the report filter the data for the user automatically. In my example pasted below, when the user opens the account, Fabrikam, Inc. in Dynamics, I want the embedded report to filter the data to only show data that is for Fabrikam, Inc. instead of showing data for all accounts or having the user select the account from a slicer.

 

dkgibbs_0-1630588580231.png

 

Meena
Frequent Visitor

Hi,

 

I have a similar requirement. Please share if you built a solution for this requirement.

 

Thank you

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors