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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
StephenWagner
New Member

How to Pass a URL Filter to Publish to Web Report

I'm trying to pass a URL filter to a published report but am unable to get it to work.

 

The report:

https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM...

 

I've tried using the method here: http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically by adding &filter=Table1/ZipKey eq '00001' to the end of the URL but that doesn't work.

 

It works for this link:

https://app.powerbi.com/groups/me/reports/8d3cbf1e-3d89-46d3-ac1a-b24d0784b125/ReportSection?filter=...

 

Any ideas?  Is this not possible?  If not, the end goal is to be able to embed this within another page, is there a different method I could use?

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @StephenWagner,

 

Based on my research, we are not able to pass filter parameter in the URL which created by "Publish to web" feature. In your scenario, to embed the report in other web pages and filter it, I would suggest you take a look at this article: Embed a Power BI report with an IFrame.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

If you want to share the reports in your organisation you can use pro licences and make a Powr BI Group. The URL ist for every user in this group the same and you can use filters.

@Anonymous@v-qiuyu-msft@ankitpatira

 

how can i add those filters to non publish to web reports?

 

and also , i don't understand where in this  article i can fine those filters to publish to web reports

 

thanks!

v-qiuyu-msft
Community Support
Community Support

Hi @StephenWagner,

 

Based on my research, we are not able to pass filter parameter in the URL which created by "Publish to web" feature. In your scenario, to embed the report in other web pages and filter it, I would suggest you take a look at this article: Embed a Power BI report with an IFrame.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

So what you are saying if you dont have powerbi premium this feature does not work with publish to web urls. You either have to embedd the app on a webpage which is a powerbi premium service or copy the URL from your browser when you are logged into the web service and actually log into the app and it works.

 

Working Example:

(https://app.powerbi.com/groups/e251475a-a633-44c5-b781-00a278dd67b4/reports/1303744f-ff1e-41ea-9f03-...%20eq%20'Brandon')

 

Cons: You have to login with powerbi user.

 

Not Working Example:

(https://app.powerbi.com/view?r=eyJrIjoiNzZmYTk3MmItMWM2MC00ZGYzLWI4ZGEtZjRhNGM3MDBhNzBlIiwidCI6IjliY...20eq%20'Brandon')

Anonymous
Not applicable

You don't need premium! But Pro Licences are nessecary.

I have Pro but the only way this works is sharing the URL from the report from my login session the published URL which we use most commonly doesnt work with the filter. 

You actually have to login to powerbi for this to work and we share many reports through a published URL.

Anonymous
Not applicable

Yes, every user needs PRO when you want to use the collaboration features. Otherwise the Workspace must have Premium capacites.

ankitpatira
Community Champion
Community Champion

@StephenWagner Have you defined them as report filters ? I have seen page level filters have not worked for me by passing via URL.

Thanks for the suggestion.  I've confirmed that ZipKey is a Report filter.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors