cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amassip Regular Visitor
Regular Visitor

Power BI Report Server : filter, filterPanel

Hello everyone,

 

With the new update (Power BI Report Server), I wonder if is it possible to hide the panel on the right ?

 

I can display a report with the following link :

 

http://ReportServer/reportsBI/powerbi/MyPowerBIReport?rs:embed=true

 

But it doesn't work this link :

 

http://ReportServer/reportsBI/powerbi/MyPowerBIReport?rs:embed=true&filterPanelEnabled=false

 

Also can we filter a report with dynamic values ?

 

Thanks in advance

13 REPLIES 13
Moderator v-qiuyu-msft
Moderator

Re: Power BI Report Server : filter, filterPanel

Hi @amassip,

 

I have sent a email to consult this issue internally. Will update to you once I get information.

 

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.
amassip Regular Visitor
Regular Visitor

Re: Power BI Report Server : filter, filterPanel

Hello,

 

@v-qiuyu-msft any news ?

Power BI Team rpatkar
Power BI Team

Re: Power BI Report Server : filter, filterPanel

hi amassip,

 

Power BI Report Server currently does not support passing in URL parameters for Power BI reports. We plan to support PBI report embed scenario in future at which point you'll be able to pass in filterPanelEnabled as well as report parameters.

Markkeny Frequent Visitor
Frequent Visitor

Re: Power BI Report Server : filter, filterPanel

Hi,

I'm having exactly the same problem. Do you know when the next version of Power BI Report Server will be released, and what it will contain?

At the moment we can do interesting proof of concepts but not integrate the reports further until this is solved. Would be better still of we could have the JavaScript API available, just as the azure platform does.

Thanks


Mark
Moderator v-qiuyu-msft
Moderator

Re: Power BI Report Server : filter, filterPanel

@amassip Below are the information after discuss with PG:  

 

The answer to both your questions is no. They will be adding the filter pane hide feature in the future but that is not public knowledge yet. Also passing parameters in URL for current PBIRS is not supported either. They didn’t mention any plans to add that feature any time soon.  And as for query parameters, you cannot do that with live connections.

 

@Markkeny We didn't get information from PG about next Power BI report server release. You can subscribe the Power BI Blog as suggested here to get latest news about PBIRS. For any question about PBIRS, you can post a thread in Report Server forum.

 

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.
Markkeny Frequent Visitor
Frequent Visitor

Re: Power BI Report Server : filter, filterPanel

Re the comment of "Also passing parameters in URL for current PBIRS is not supported either. They didn’t mention any plans to add that feature any time soon", I think the product group should think about this again.

 

Imagine the scenario where we have an enterprise wide reporting system based off the MS BI Stack, and the final front end is a Power BI Report connecting to a Tabular cube hosted on Power BI Report Server.

 

Now not everyone in the organisation can see every part of the data, for example the sales force in the US cannot see the figures for the sales force in the UK and vice versa.

 

So we create a Power BI report that contains everything and by default it will open with whatever filters we had in place when we saved it to the Report Server, so what we need to do now is to over-ride those filters with the ones that are appropriate for that specific user.

 

How would we permission Power BI reporting correctly in that scenario ?

 

Thanks very much

 

Regards,

 

 


Mark

Markkeny Frequent Visitor
Frequent Visitor

Re: Power BI Report Server : filter, filterPanel

All,

 

I have just downloaded and installed the GA release of Power BI Reporting Services dated October 2017, and am not seeing a way to hide the filter pane.  Please could you confirm whether this feature made it into this release, or not, and if it did what the correct syntax for usage is ?

 

Thanks very much

Power BI Team rpatkar
Power BI Team

Re: Power BI Report Server : filter, filterPanel

Hiding filter pane was not part of the October 2017 release. It will likely be part of a future release, we do not have a timeline to share yet. Thanks.

gourangib Frequent Visitor
Frequent Visitor

Re: Power BI Report Server : filter, filterPanel

Hi,

This is "MUST" feature because with the latest version we can filter data by passing logged in user but if we show filter panel on the page then the user will get access of all the other users and data as well..

 

THIS IS CRITICAL ..

 

This should be taken up on priority.

 

Thanks,

Gourangi

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!