Forum Discussion

Boyan's avatar
Boyan
Icon for Helper I rankHelper I
5 years ago
Solved

How to enable filtering when publishing a report to SharePoint as embed - it works in PBI service?

Hi everyone,

 

I noticed that when I publish my report to the Power BI service I see the filter pane to the right and I can expand it and use it to apply filters. Again this is outside of Power BI Desktop -- it is the PBI service app.powerbi.com and the report works just as expected.

 

However if I publish that report to SharePoint using the embed link everything works fine except the filter pane is just missing. How can I enable it so that those who consume the report in SharePoint can use filtering?

 

Thank you, here is a screen shot of how my report looks in PBI service. You clearly see the filter pane to the right and it works as expected:

 

4 Replies

  • Hi Boyan ,

     

    Do you have the Eye selected on the filter so that it is available to other readers?

     

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

    • Boyan's avatar
      Boyan
      Icon for Helper I rankHelper I

      GilbertQ YES Thank you Gilbert. It was the SharePoint web part configuraton - simple toggle switch to show the filter pane. Thank you a million! That did it for me. Also thank you to all those who replied with suggestions for me. Apprecaite this community very much,

       

      Boyan