The URL of a page showing a filtered result does not have the &filter portion?

[Pp110784]

I have a report with a table visual. The table has a column for plan sponsor names. I have set up a drillthrough page for it called plan sponsor details page. When we right click on any plan sponsor's name on the main page, we get the option to drillthrough to the plan sponsor details page. I uploaded this report to an app in the power BI service workspace. There let's say, I right click on plan sponsor 'at&t' and select drillthrough & go to the plan sponsor details page. That page is showing me the details for at&t only, but the URL of this page does not have the /filter portion at all. 

Like in the screenshot below, I selected the drillthrough for plan sponsor name 'FEDERAL RETIREMENT THRIFT INVESTMENT BOARD':

This page's (the main page's) URL is: https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/1bb07691c32ca1892215?experience=power-bi

And the destination page's (plan sponsor details page's) URL is: https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/d934f2e42d3c3506d7e8?experience=power-bi

I need the URL to have the filtered plan sponsor's name, because I am trying to set up a URL to go to the plan sponsor details page instead of the drillthrough option, and I cannot build a URL for that if it doesn't have the plan sponsor name.

Also my data table's name has spaces. For e.g. ABT Table Data, and the plan sponsor's name can have special characters like ' ( - & etc. How will these be transformed in a URL link?

I referred to this QnA post to get the power BI URL formation logic -

https://community.fabric.microsoft.com/t5/Service/Power-BI-report-URL-filter-not-working/m-p/4232823

[lbendlin]

Drillthrough transfers the filters internally, it does not expose them in a URL.

For special character encoding refer to the documentation: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

[Pp110784]

Is there any way I can configure the report so that it changes the URL of the drillthrough page, such that it shows the filters?

[lbendlin]

Not currently possible.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[Pp110784]

All the videos and training manuals that I read said that once a report is uploaded to PBI service and any filters are applied to it, the URL will show that. So I created a separate report for the plan sponsor details page and uploaded it in PBI service with all the plan sponsor's names. Then using filters, I selected a single plan sponsor name so the report was showing me the details for just that plan sponsor, but still the URL did not change. Am I doing something wrong?

The unfiltered report. URL - https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/d934f2e42d3c3506d7e8?experience=power-bi

Then filtered the report for a particular plan sponsor:

Still the URL remained the same:

https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/d934f2e42d3c3506d7e8?experience=power-bi

Should I be using some other visual type, instead of a table or a matrix?

[lbendlin]

 once a report is uploaded to PBI service and any filters are applied to it, the URL will show that.

news to me. Do you have pointers to official documentation?

[Pp110784]

On this page - https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

I tried both these options, but none of them is working.

[lbendlin]

That page does NOT state that user interaction with the report will result in the URL being updated.  In fact the exact opposite is true.  Report URL filters can be overridden by user interaction.

[Pp110784]

oh! ok. I misunderstood then.

I was also wondering, why does my report's URL have an extra id kind of section in it. Do you know? https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/d934f2e42d3c3506d7e8?experience=power-bi

This d934f... one. I am just so confused that my report's URL is not following the standards. Any pointers towards understanding that would be highly appreciated.

[lbendlin]

"ReportSection"  means page.  Without additional ID it will be the default page (the one you had open when you published.

You can use the EmbeddedPlayground to enumerate report pages and page visuals.

[Pp110784 · Accepted solution]

I was able to figure out how to make filters work with the URL. I need to put the filters before the &experience=power-bi portion, like https://app.powerbi.com/groups/me/apps/[id]/reports/[id]/d934f2e42d3c3506d7e8?filter=ABTTableData/PL...