Power BI On Prem - pass filter via URL not working since Jan update

[Anonymous]

Hi, we have a system that has a link to one of our PBI reports on it. When the link is clicked, it passes the users username to the URL and shows them their dashboard (filtered by their username)

I updated the PBI Report server on Friday and since then, when a user clicks on the link the report doesn't load. It will say "Loading data" for a split second and then turn to a blank white screen. No data or visuals.

The below is the URL we are using - does anyone know how to fix this?

http://mansqlssrs03/pbireports/powerbi/Advice/Dashboards/Advisory%20Operations%20Realtime%20Consultant?filter=Advice_Users%2FAdviceUsername%20eq%20'John.Smith'

[v-yangliu-msft]

Hi  @Anonymous  ,

You can try the following two methods:

1. Cache clearing in the browser.
2. In your report page filter, whether there is a boolean value (XXX = TRUE), you can change the boolean value in the table (and in the filter) to a numeric value (XXX = 1),If not, you can clear the filter on the page and repost.

This is the relevant document, I hope to help you:

https://community.powerbi.com/t5/Report-Server/After-a-scheduled-refresh-the-report-has-no-data/td-p/312091/page/2

https://community.powerbi.com/t5/Service/Power-BI-Report-not-showing-data-after-publishing-to-Service/m-p/413508

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I looked in the console for any errors and saw the below - has anyone had anything similar?

[Anonymous]

Does anyone have any ideas on how to fix this or what the correct URL would be to filter the report?

spoke to IT about downgrading the PBI report server but doesn't seem as though this is an option. 

the data source I am using is SSAS tabular direct query