Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Team,
Is there anyone here to have an idea how to filter Power BI report CRM form. So for example, I embed the report in Account Form, so if I go to Account --> "TestAccountName", then the form it will show the Power Report with filtered data (Account = "TestAccountName")
Embedding Power BI to form
http://www.toplinestrategies.com/blogs/bi/embedding-powerbi-report-crm-form
Filtering Power BI
https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/
Hi @rommel20,
For your scenario, URL filter feature may suitable for your requirement, but current URL fitler feature not works on 'publish to web' reports.
In my opinion, you can try to use power bi embedded report with URL filter.
Filter a report using query string parameters in the URL
Regards,
Xiaoxin Sheng
yeah, but my problem is were using Power BI Report Server, how is that?
HI @rommel20,
>>yeah, but my problem is were using Power BI Report Server, how is that?
Maybe you can refer to below article:
Quickstart: Embed a report using an iFrame
Regards,
Xiaoxin Sheng
Thansk! @v-shex-msft
yeah, i think i have a big problem since in Power BI Report Server, we cant add filter on its link unlike report on cloud (app.powerbi.com)
HI @rommel20,
It seems like that query string only allow embed parameter and not available as url filter.
Regards,
Xiaoxin Sheng
Good afternoon! We are basically looking for the same feature... we are looking how to embed a power bi chart inside a CRM account, and filtered by the account.
We saw that "Publish to Web" option encodes the URL making it imposible to use with filters, don't now if this is being developed or not.
We also saw that using the internal URL with the filter option in the URL does not display when rendering from CRM Online...
Does anyone know how to make it work?
Thanks in advance!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
23 | |
21 | |
19 | |
10 |
User | Count |
---|---|
37 | |
36 | |
34 | |
20 | |
14 |