topic Re: Power BI Report Server : filter, filterPanel in Report Server

Power BI Report Server : filter, filterPanel

amassip — Tue, 06 Jun 2017 15:20:07 GMT

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

Re: Power BI Report Server : filter, filterPanel

v-qiuyu-msft — Wed, 07 Jun 2017 06:36:47 GMT

Hi @amassip,

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

Best Regards,
Qiuyun Yu

Re: Power BI Report Server : filter, filterPanel

amassip — Mon, 12 Jun 2017 07:04:21 GMT

Hello,

@v-qiuyu-msft any news ?

Re: Power BI Report Server : filter, filterPanel

rpatkar — Sat, 17 Jun 2017 00:28:06 GMT

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.

Re: Power BI Report Server : filter, filterPanel

Markkeny — Wed, 21 Jun 2017 17:50:24 GMT

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

Re: Power BI Report Server : filter, filterPanel

v-qiuyu-msft — Sat, 24 Jun 2017 02:16:55 GMT

@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

Re: Power BI Report Server : filter, filterPanel

Markkeny — Sat, 24 Jun 2017 12:32:59 GMT

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

Re: Power BI Report Server : filter, filterPanel

Markkeny — Tue, 07 Nov 2017 12:10:39 GMT

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

Re: Power BI Report Server : filter, filterPanel

rpatkar — Tue, 07 Nov 2017 18:41:29 GMT

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.

Re: Power BI Report Server : filter, filterPanel

gourangib — Wed, 15 Nov 2017 05:28:18 GMT

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

Re: Power BI Report Server : filter, filterPanel

huyq2002 — Tue, 19 Dec 2017 08:16:06 GMT

The user can easily copy the report ULR and change the filterPanelEnabled setting and then open it in browser.

Now he can access full data.

Access control with query string is not a good solution at all.

Microsoft BI solution security based on AD, which can not easily works accross internet.

Re: Power BI Report Server : filter, filterPanel

mstacey — Fri, 29 Dec 2017 10:59:04 GMT

Any later updates on hiding filter pane and choosing page for navigation, plus hiding page?
We got parameters, when will we get the rest?

Re: Power BI Report Server : filter, filterPanel

mstacey — Fri, 29 Dec 2017 11:02:05 GMT

I would certainly agree that hiding the filter pane and page navigation are vital features. Our users want to be able to manage and deploy power bi charts that we embed into our applications and also into PDF reports and we need to be able to hide these

Re: Power BI Report Server : filter, filterPanel

karthikvalluri — Thu, 24 May 2018 09:29:15 GMT

Any update/timeline when this feature will be rolled out @v-qiuyu-msft - Thanks,karthik