Dynamic filtering in reports published to SharePoint

[Anonymous]

I have a published report with several pages that I want to use in Sharepoint. On teh PowerBI desktop, I use a filter that applies to all pages to select a single customer for the presentation of the report to the Sharepoint page using the PowerBI WebPart. I want to create multiple SharePoint pages on the same SharePoint site, each with a different customer filterred. I also need to lock the filters once set so that users cannot change the customer being viewed on a SharePoint page. Is that possible?

[SivinSidharthan]

Is there any hope for this solution.

[Icey · Accepted solution]

Hi @Anonymous ,

Based on my test, it is not supported currently.

In addition, how about applying Row Level Security to restrict the data for each customer? RLS will work when using the new Embed in SharePoint Online option.

Reference: Embed a report web part in SharePoint Online - Power BI | Microsoft Docs

Best Regards,

Icey

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

[Anonymous]

I am using the PowerBI Embedding. Are you referring to some other integration for SharePoint?

[lbendlin]

Don't do that.  Your users will hate it because they have to repeatedly log in to Power BI from the sharepoint page, and the very first thing they will try to do is change filters which you plan to prohibit. 

Instead, explore the proper Power BI Embedded option (not the iframe klutz).