Forum Discussion
Persistent filters when embedded in SharePoint
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
Hi Anonymous ,
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
2 Replies
Hi Anonymous ,
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