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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Report URL FIlters not carrying through into POwer Service Published Report

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 and find the published 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.

 

  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

The filter is still kept if you open it from desktop using above 2 methods. More details please refer : https://docs.microsoft.com/en-us/power-bi/service-share-reports

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

@Anonymous ,

 


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 and find the published 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.


So what's your issue or requirement? Could you please clarify more details about the issues or requirement?

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 


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 and find the published 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.


So what's your issue or requirement? Could you please clarify more details about the issues or requirement?

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Apologies accepted by mistake. The issues is when i go to the file in my work space there are no filters applied as per URL Hyperlink.

 

quote"however, when i go to my workspaces and find the published 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."

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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