Forum Discussion
Advocate IIIPower BI report URL filter not working!
Hi everyone,
one of my old project which had report url with filter pointed to another report and that used to work fine but recently I noticed it is no longer working and the format of the report url has been changed as well. It no longer has ?ReportSection and ?filter = <Table>/<Column> eq '<value>' at the end of the URL no longer works.
Right now it is as following which is not working as well. Can somebody help me with this?
Thanks!
Hi. The power bi traditional url has changed. Now it has a parameter at the end. The "experience = powerbi". The way URL works, when the "?" starts it means you will define parameters next. It can only contain one question mark. After one parameter you can add any other with "&" symbol. Check your URL and replace the ? for & like:
https://app.powerbi.com/groups/[group_id]/reports/[report_od]?experience=power-bi&filter=Table/Column eq 'PA'I hope that helps,
5 Replies
- ibarrau
Super User
Hi. The power bi traditional url has changed. Now it has a parameter at the end. The "experience = powerbi". The way URL works, when the "?" starts it means you will define parameters next. It can only contain one question mark. After one parameter you can add any other with "&" symbol. Check your URL and replace the ? for & like:
https://app.powerbi.com/groups/[group_id]/reports/[report_od]?experience=power-bi&filter=Table/Column eq 'PA'I hope that helps,
- k3rz0rg
Hi ibarrau ,
thank you for your prompt response and your solution appears to be working. That & and single quote info was I was missing.
I have couple of questions, if I had multiple filters, should I keep on adding those with & or there's limitation on that? And the other one is, I use the following code where if nothing is selected, it will select max value or min value by default from the slicer, (I'm using this in button), is there any way to set all by default?SELECTEDVALUE('Transaction'[State], MAX('Transaction'[State]))Thanks!- ibarrau
Hi. Slicers can't configure values by default or logics. You could check the prefilter slicer custom visual.
Regarding url filters you can add more than one writing the word " and " like the docs specify: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#filter-on-multiple-fields
Regards
Hi, k3rz0rg
Thanks for ibarrau's reply. Here are additional information about this, you can read the document to get more information.
Filter a report using query string parameters in the URL - Power BI | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
