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

[Boyan]

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:

[GilbertQ · Accepted solution]

Hi @Boyan 

You will need to go to the Sharepoint page and make sure you have enabled "Show Filter Pane"

Here is more information

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-scenario-embed-report

[Boyan]

@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

[GilbertQ]

Awesome, thanks for letting me know it worked!

[collinq]

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!