Pre selection of filters in a power bi report embedded into sharepoint

[Anonymous]

Hi

i have the following problem:

When i try to pre select the filters in a powerbi report embedded in sharepoint with the following url

"POWERBI-REPORT-URL"/ReportSectiondc5c666ba8b170ed01ba?filter=projects/pmonummer eq 'EM010'

the pre selection of filter does not work in Sharepoint, however it works if i open a new tab in my browser.

I'd like to not show the navigation, filter or action tab since it will not be relevant for the users and it give a more smooth layout.

We are creating new sharepoint site for every major project we have, and would like to embed Powerbi report, it would be lovely to could use the same dashboard with a filter for all cases, instead of having to make a new page for each project.

Thanks in advance

Martin

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

It's a known limitation.

Filter a report using query string parameters in the URL 

Sharpoint web part accepts the url if you add &filter=... to the end of it but currently has no effect. 

For your requirement, you can vote for this idea  on Power BI Ideas forum and add your comments there to make this feature coming sooner. 

Best Regards,
Community Support Team _ Eason