cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217 Member
Member

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

Accepted Solutions
Community Support Team
Community Support Team

Re: Report URL FIlters not carrying through into POwer Service Published Report

@Route217 ,

 


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
Community Support Team
Community Support Team

Re: Report URL FIlters not carrying through into POwer Service Published Report

@Route217 ,

 


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

Highlighted
Route217 Member
Member

Re: Report URL FIlters not carrying through into POwer Service Published Report

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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,960)