Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

URL Filter not working on report in App Workspace

Hi

 

I've got a site report that I use url paramaters to direct users to a specific site, based on the site code. this works in "My" Workspace

https://app.powerbi.com/groups/me/reports/[ReportID]/ReportSection?filter=SiteInfo/SiteCode eq '3408'

 

However, when I publish the exact same report to an App Workspace, the URL filters fail.

https://app.powerbi.com/groups/63805a40-89ff-4fa4-8a2e-55055ef0903d/reports/[NewReportID]/ReportSect...

 

The report comes back non filtered, and I can see the url parameter being removed from the URL. I've tired a couple of reports with the same behaviour. Can we not use URL filters on app workspace reports? 

 

 

Can anyone replicate and confirm it's not just me? 

 

 

Status: Accepted
Comments
christianb_7
Regular Visitor

Hi, does anyone know of an update to this? 

 

I am trying with the following encoding for the end part of the url.  It is working in the browser, but now when it is opened in the Power BI iPad app.

 

ReportSection?filter=MyTable%252FMyColumn%20eq%20%27MyRow1%27

 

Thanks,

Chris

AJTindall73
Advocate I

I think it should be reminded if you are doin this with an app you should include the ctid.

 

Extract from https://docs.microsoft.com/en-us/power-bi/service-url-filters

Reports in apps

If you want to add a URL filter to a report in an app, the formatting is a little different. Links to reports in an app have a query parameter (ctid) that gets added to the URL. Query parameters need to be separated by an ampersand (&). So you need to append the query with “&filter=” (after the ctid parameter) instead of “?filter=”.

Like this example:

app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?ctid=ctid&filter=Table/Field eq 'value'

 

 

Hope this helps people 🙂