cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

URL Parameter FIlter - Issue.

Hi Expert

 

I have tried the following, not sure what i am doing wrong here (See below).  i have published a report to PBI Services, i have a query string URL as per point 2.2 below.

 

When i click the URL is takes me to a new PBI Services window with the filters applied. HAPPY.

 

However, when i go to my workspaces to find the published PBIX report the filter are what they where when i initially published the PBIX file.

Surely the filter from the Query String Parameter should have carried through into the Publish PBIX file and retained in PBI Service until the uRL is changed.

 

Question is it possible to retain filtering in a PBIX Report Published to APP workspace when using a URL Paramters. Attached is a sample file. 

1.Please publish the second tab "Duplicate of complnay details" to your app work space

2. update the URL = Measure is Report URL

3. click the url link in Company details and see what happens, this takes you to a new window within PBI Service and the filter sare applied.

4. then click back to your workspce and see if the filter have carried through to your original PBIX file you published to your APP Workspace

 

https://www.dropbox.com/s/o4mcgbu13msbofi/URL_Link_Test_File_7.pbix?dl=0

 

 

 

  1. Please make sure the option wasn’t ticked in your desktop. Otherwise the filter will be reset every time.111.png
  2. If you didn’t tick the option above, could you please share us the detailed procedure that you created the functional filter URL?

There’s 2 ways to filter the report in service, and get the link related.

  1. Open the report in Editing view, apply the filter, and save the report. Then simply copied the URL link generated.
  2. Filter a report using query string parameters in the URL

 

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

Hi @Anonymous ,

AFAIK, 'persistent filter' option not affect url filter, it only reset filter changes your applied on report read view mode.

Announcing Persistent Filters in the Power BI Service

Url filter is applied on url string, its changes will been reset if you reload web page(original report url). I don't think it is possible to keep these changed url strings

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
AndrewFin
New Member

Does the same url format apply when the report is public (published to web)? I find that the filter won't apply to a public report.

v-shex-msft
Community Support
Community Support

Hi @Anonymous ,

AFAIK, 'persistent filter' option not affect url filter, it only reset filter changes your applied on report read view mode.

Announcing Persistent Filters in the Power BI Service

Url filter is applied on url string, its changes will been reset if you reload web page(original report url). I don't think it is possible to keep these changed url strings

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.