Forum Discussion
Advocate IUrl Parameters dont filter when report published to app
Hi
I have published a report to my workspace and the URL filter works fine
however, when I publish the EXACT SAME report to a shared workspace, the url parameter fails to work
https://app.powerbi.com/groups/63805a40-89ff-4fa4-8a2e-55055ef0903d/reports/[REPORTID]/ReportSection?filter=PubInfo%252FPHC%20eq%20%273408%27
Please advise
Morning
I've resolved the issue. The filter doesnt work with the link to the group workspace.
BUT if you retrieve the report from the "View Content List" on your app, then its a different URL, and the filter parameter works on this one!
Can I give myself Kudos?
hi
Yep, got this working. Steps I followed are below
1. Open app
2. Go to "View Content List" (top right - icon looks like bullet points)
3. Click on the report you want to filter. This will take you to the app published version of the report, and the URL should include the words APPS in the string (see below)
https://app.powerbi.com/groups/me/apps/xxxx-xxxx-xxxxx-xxxxx/reports/xxxx-xxxx-xxxxx-xxxxx/ReportSection
as opposed to the workspace version which wont have the app reference
https://app.powerbi.com/groups/xxxx-xxxx-xxxxx-xxxxx//xxxx-xxxx-xxxxx-xxxxx/ReportSection
4. You can then add your URL parameters to this new URL as per below
https://app.powerbi.com/groups/me/apps/xxxx-xxxx-xxxxx-xxxxx/reports/xxxx-xxxx-xxxxx-xxxxx/ReportSection?filter=TableName/FieldName eq '12345'
Hope this helps
Warwick
13 Replies
v-qiuyu-msftCommunity Support
Hi WCONGRAVE,
Based on my test. the URL query parameter also can work in group workspace. There are some limitation to use URL parameter, please take a look at this blog: Filter a report with a URL query string parameter.
In your scenario, please append the ?filter=<Table>/<Field> eq 'value' after the report URL, make sure field type needs to be string.
Best Regards,
Qiuyun Yu
WCONGRAVEThanks, but I cant get it to work.
I accidentally created 2 posts for this issue (https://community.powerbi.com/t5/Issues/URL-Filter-not-working-on-report-in-App-Workspace/idi-p/191129) and there's 2 other users experiencing the same issue as me.
I'm pretty sure this was working prior to the 1st June, not sure if that change has anything to do with it...
- WCONGRAVE
Morning
I've resolved the issue. The filter doesnt work with the link to the group workspace.
BUT if you retrieve the report from the "View Content List" on your app, then its a different URL, and the filter parameter works on this one!
Can I give myself Kudos?
