Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic filtering in reports published to SharePoint

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?

Dynamic
Filter
multiple
SharePoint

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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).

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

     

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    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.