Forum Discussion
Helper IIINeed help with URL to pass filter to PBI Svc Rpt - CTID
[We're a social services nonprofit so thanks in advance for reviewing our question!]
We're successfully using a URL-passed-filter for a report so now I'm trying to replicate it for a new report (named SMMTP {self medication treatment plan} - see screenshot below) The good news is that the new link brings up the new report.
But this new report is not filtering... could my problem be the "ctid"... is this the same for all reports across all workspaces in our PBI Svc? Where do I find the "ctid"??
Passing URL Rpt Parameter
Here's a screenshot of the DnE report that is working (passing the ID as a filter)
I've replicated the URL from this "Day & Employment" report (in a different Workspace) since it successfully passes a Record ID as a filter to Power BI Service:
https://app.powerbi.com/groups/XXX15c13-45f9-4566-99d1-47999704ba84/reports/XXX6d966-9339-473e-b6b2-1211d1097549?ctid=XXXe04eb-57fe-4568-9770-3ff9a4fb6982&filter=Service_Plan/Id eq 'XXXU000000JmaEQAS'
To make is easier to read:
https://app.powerbi.com/groups/XXX15c13-45f9-4566-99d1-47999704ba84
/reports/XXX6d966-9339-473e-b6b2-1211d1097549
?ctid=XXXe04eb-57fe-4568-9770-3ff9a4fb6982
&filter=Service_Plan/Id eq 'XXXU000000JmaEQAS'
So my attempt at a replicated link is:
https://app.powerbi.com/groups/XXXcd887-a73c-416a-962c-fb2723159b75/reports/XXXb07d4-86d8-405d-b6b8-3b3da13ed75e/ReportSectionXXXb1a663c496010e9ce?ctid=XXXe04eb-57fe-4568-9770-3ff9a4fb6982&filter=Service_Plan/Id eq 'XXX4w00000Ah5etAAB'
And parsed for easier reading:
https://app.powerbi.com/groups/XXXcd887-a73c-416a-962c-fb2723159b75
/reports/XXXb07d4-86d8-405d-b6b8-3b3da13ed75e
/ReportSectionXXXb1a663c496010e9ce
?ctid=XXXe04eb-57fe-4568-9770-3ff9a4fb6982
&filter=Service_Plan/Id eq 'XXX4w00000Ah5etAAB''
The "ctid" seems to be a possible issue... removing the ReportSection just results in it returning with the link is executed - but the filter is still just a warning
Any suggestions for fixing my URL would be much appreciated!
3 Replies
Hi @JDBOS,
I'd like to suggest to copy your filter query, after other users locate to the report, let him paste the query after current url.
Extract from https://docs.microsoft.com/en-us/power-bi/service-url-filters
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'
This solution is referenced from URL Filter not working on report in App Workspace - Page 2 - Microsoft Power BI Community.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JDBOSAnonymous thanks for your response - from my original msg, here's the parsed URL I'm using with does include the ctid which I've confirmed as correct. I've also confirmed that the Record ID does exist in the table
https://app.powerbi.com/groups/XXXcd887-a73c-416a-962c-fb2723159b75
/reports/XXXb07d4-86d8-405d-b6b8-3b3da13ed75e
/ReportSectionXXXb1a663c496010e9ce
?ctid=XXXe04eb-57fe-4568-9770-3ff9a4fb6982
&filter=Service_Plan/Id eq 'XXX4w00000Ah5etAAB''
I'll work through the other Community link that seems to be related to a legacy issue which I assume has been solved.
From my original msg, I have two URL, one passes a filter and the other doesn't - so something is different between them....
Hi JDBOS ,
Has your problem been solved? If not, is there anything I can do to help you. If it has been solved, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
