Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community
Persistent filters don't seem to work when a Power BI report is embedded into a SharePoint site.
Is there any way to use this feature when embedded in SharePoint?
Thanks
Solved! Go to Solution.
Hi @Jeeks ,
In my test, after the report applied URL FILTER is embedded in SharePoint, its filtering is Persistent.
1.Filter single value: Add ?filter=Table/Column eq ‘Value’ .
2.Filter multi values: Add ?filter=Table/Column in( ‘Value1’,’Value2’) .
3.Filter multi columns: Add ?filter=Table/Column eq ‘Value1’ and Table/Column eq ‘Value3’.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Jeeks ,
In my test, after the report applied URL FILTER is embedded in SharePoint, its filtering is Persistent.
1.Filter single value: Add ?filter=Table/Column eq ‘Value’ .
2.Filter multi values: Add ?filter=Table/Column in( ‘Value1’,’Value2’) .
3.Filter multi columns: Add ?filter=Table/Column eq ‘Value1’ and Table/Column eq ‘Value3’.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.