Report filters not respected in SharePoint web part

[cema]

Hi all,

I'm trying to create a SharePoint showing the same report but with different filters to show different data. The issue is, even though the URL I'm using for each web part is different (reflecting the different filters), it seems that none of the filters are being respected. Each report loads up with no filters.

Is what I'm looking to do a supported scenario? If so, can you please share docs or a step-by-step so I can see where I'm going wrong? It seems straightforward so I'm not sure what I could be missing.

Thank you!

[lbendlin]

show a sample URL with your filters. Remember you have to escape all kinds of characters in a very specific way.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

[cema]

Here is an example:
https://msit.powerbi.com/groups/ebc9915a-2b8a-403f-8ee8-fa06530b4527/reports/e2fc6005-fa94-4b96-8beb...

I get this by:
1. In PowerBI online, filter the report as desired

2. Hit Share -> Report

3. Send to myself and check "Include my changes"

4. Hit Share

I see that the URL above is different from the ones in the docs. Do those have to be created manually? Or, is there a way to take a filtered report and generate the required URL?

[lbendlin]

Your example is using a bookmark, not filters.  Your choice, really. I don't know how well bookmarks are supported in your setup.

[cema]

I totally see the difference now. The question is: is there any way to generate a proper filter URL, without typing it out manually? What are the steps to do so?

[lbendlin]

not to my knowledge.  You could go all cute and translate the layout.json to a query string but I haven't bothered to dabble in that yet.

What's wrong with crafting the query string manually? 🙂

[cema]

It seems straightforward but no luck yet. Here is the URL I am using to filter Domain to "acp.at", no luck with this URL in a browser window. The report loads with default filters. Is something missing?

https://msit.powerbi.com/groups/<groupid>/reports/<reportid>/ReportSection?filter=Domain eq 'acp.at'

[lbendlin]

you need to specify the table as well

?filter=Table/Field eq 'value'

[cema]

Thank you for your quick reply!  I got the filter URL working in browsers now without issue, but filters are still not being respected in SPO.

Below is the URL I am using. Both work of these in browsers, but neither is working when copied to the SPO web part. The report with default filters is still what shows in SPO.  I've even tried to empty cache and hard reload with the same result. Am I missing something here?

https://msit.powerbi.com/groups/<groupid>/reports/<reportid>/ReportSection?filter=Messages/Message_x... ge 2020-09-01 and Messages/Message_x0020_Date lt 2020-10-01

https://msit.powerbi.com/groups/<groupid>/reports/<reportid>/ReportSection?filter=Messages%2FMessage...

[cema]

Here is the end of that URL:

ReportSection?filter=Messages/Message_x0020_Date ge 2020-09-01 and Messages/Message_x0020_Date lt 2020-10-01

ReportSection?filter=Messages%2FMessage_x0020_Date%20ge%202020-09-01%20and%20Messages%2FMessage_x0020_Date%20lt%202020-10-01

[cema]

Hi all - any update on this?