Dynamic filtering URL issue

[krzysztof]

I have a report with a link: https://app.powerbi.com/groups/me/apps/ac1fa691-e0ca-44a9-b373-6d713a9d5555/reports/3ab06284-3096-4b...

The report has a table with a name DWH_MAGENES V_DimMagenesStyleColors and a column EAN. 
I have a table in another report with EAN column elements. I would like to make a dynamic link to this report that will filter the report by a specific EAN. Ean is a text column. Example ean 5903698746425

[V-yubandi-msft]

Hi @krzysztof ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @krzysztof ,

We haven’t received a response yet and want to ensure the solution met your needs. If you need any further assistance, feel free to reach out we’d be happy to help. If everything is working as expected, kindly mark it as Accepted as solution.

Thank You.

[V-yubandi-msft]

Hi @krzysztof ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.

[rohit1991]

Hi @krzysztof ,

You’re definitely on the right track with dynamic URL filtering in Power BI, but there are a couple of things to double-check with the URL format:

First, make sure there’s only one question mark (?) after your report ID in the URL. After that, every additional filter or parameter should start with an ampersand (&). So, it should look something like this:

https://app.powerbi.com/groups/me/apps/.../reports/.../ReportSection?filter=YourTable/YourColumn eq 'YourValue'

If you want to filter by EAN (as a text field), your filter at the end would be something like:

?filter=DWH_MAGENES_V_DimMagenesStyleColors/EAN eq '5903698746425'

Just make sure any spaces in table or field names are replaced with %20, and everything matches the exact case and spelling used in your model.

To create fully dynamic links from another table, you can build the full URL in a DAX measure, referencing your EAN column. Then, display that DAX measure in a table visual as a clickable link, or use it with a button. If you want to take it a step further, you can even add page names or bookmarks to the URL (e.g., &pageName=ReportSection2) so users land exactly where you want after filtering.

If you’re still not seeing the results you expect after setting this up, double-check your data model relationships and make sure the column you’re filtering by is visible and correctly referenced in the target report.

[krzysztof]

So this is what the sample link would look like? If so, unfortunately it doesn't work:

https://app.powerbi.com/groups/me/apps/ac1fa691-e0ca-44a9-b373-6d713a9d5555/reports/3ab06284-3096-4b67-801b-57775508dae7/3202c5fdce77849db8d1?experience=power-bi?filter=DWH_MAGENES%20V_DimMagenesStyleColors/EAN%20eq%20'5903698746425'

I marked the fragment with spaces:
DWH_MAGENES%20V_DimMagenesStyleColors/EAN%20eq%20'5903698746425'

[V-yubandi-msft · Accepted solution]

Hi @krzysztof ,

The issue is with the URL structure. When adding extra parameters like filter=, you should use & to connect them, not another ?.

1. There should be only one ? after /reportid.
2. Additional parameters should be added using &, like &filter=....

If you want to create dynamic links for different EANs in Power BI, use a DAX measure. Display the links in a table visual and format them as Web URLs for easy access and clicks.

FYI:

For more details, here the official Microsoft documentation you can refer 

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

I hope this helps. If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.