topic Re: Hide filter pane on Embedded report in Report Server

Hide filter pane on Embedded report

muchinski — Thu, 23 Nov 2017 12:18:23 GMT

Hello guys,

I am using Power BI Report server for some months here and now we are starting to embed some content on our SharePoint.

The problem is that I am not being able to hide the Filters pane with an URL option.

I am using the following string after the URL:

?rs:Embed=True&filterPaneEnabled=False

Does anyone have an idea? Is it supported by the Report Server?

Re: Hide filter pane on Embedded report

v-yulgu-msft — Fri, 24 Nov 2017 02:35:59 GMT

Hi @muchinski,

The property &filterPaneEnabled=False to hide the filters pane works in Power BI service embedded report. For Power BI Report Server, it is not a supported feature in current release. It will likely be part of a future release.

Regards,

Yuliana Gu

Re: Hide filter pane on Embedded report

nchambe — Mon, 15 Jan 2018 17:08:54 GMT

Any update on this possibility for report server?

Re: Hide filter pane on Embedded report

Anonymous — Thu, 12 Apr 2018 18:36:09 GMT

Hi guys. Any update on this? I'm a little surprised this has been talked about on the community for a while but still not rolled out.

This is something critical for implementation as the Report Server doesn't yet support RLS.

Re: Hide filter pane on Embedded report

karthikvalluri — Thu, 24 May 2018 06:39:23 GMT

Any update on this feature? We are using Sharepoint to embed PBI report.

Re: Hide filter pane on Embedded report

sysadm01 — Wed, 11 Jul 2018 22:01:57 GMT

Power BI Report Server users can use the following workaround.

You can place white box on top of the Filters pane.

Use the following snippet to achieve that. Adjust containers' width and height to meet your needs.

<script src="../siteassets/js/jquery-1.12.4.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
	var frame = '<iframe width="100%" height="100%" 
                     src="http://server/powerbi/report?rs:Embed=true"></iframe>';
	$("#framecontainer").append(frame);
})
</script>
<style>
	.ms-webpartPage-root{border-spacing:0;}
	#reportcontainer{width:910px;height:750px;}
	#framecontainer{float:left;width:875px;height:750px;}
	#shield{
           position:relative;
           float:left;
           width:34px;
           height:750px;
           background:white;
           left:-34px;
        }
</style>
<div id="reportcontainer">
<div id="framecontainer"></div>
<div id="shield"></div>
<div style="clear:both;"></div>
</div>

Re: Hide filter pane on Embedded report

karthikvalluri — Thu, 12 Jul 2018 02:17:10 GMT

Appreciate the response. But was thinking what if the size of the page changes? will this white box be exposed then or it will it adjust accordingly? Sorry im not much into JS. Thank you.

Re: Hide filter pane on Embedded report

sysadm01 — Tue, 17 Jul 2018 14:12:34 GMT

@karthikvalluri wrote:
Appreciate the response. But was thinking what if the size of the page changes? will this white box be exposed then or it will it adjust accordingly? Sorry im not much into JS. Thank you.

If size of the page changes, the report will scale within the iframe. If needed iframe size can be adjusted changing embedded CSS style width and height for #reportcontainer and #framecontainer elements. For the #shield element only height needs to be adjusted.

Re: Hide filter pane on Embedded report

dpombal — Wed, 05 Sep 2018 21:15:18 GMT

Any update on this feature¿

Re: Hide filter pane on Embedded report

sulli01 — Fri, 07 Sep 2018 18:03:31 GMT

Thanks Yuliana!

Where can we find documentation or a dictionary of all PBI proprties and thier respective function? I've seen many responses like yours that give one piece, but a list would be helpful. Thanks!

Re: Hide filter pane on Embedded report

Arnaud_R — Thu, 11 Oct 2018 08:10:31 GMT

Hi,

A turn around is to create a separate page where you place the filters.

Synchronize those filters with all the other pages of the report.

Hide this page.

Re: Hide filter pane on Embedded report

Arnaud_R — Thu, 11 Oct 2018 08:27:11 GMT

Possible turn around:
- Create a new page
- add the filters and synchronize them with all the pages of the report
- hide this page

Re: Hide filter pane on Embedded report

sureshbellevue — Sat, 13 Oct 2018 16:39:33 GMT

I am looking for the option to hide only on report level on embedded power bi, but would like to show page filter and visual filter is there any option. Please help me finding suitable solution

Re: Hide filter pane on Embedded report

FrancoiseLB — Tue, 16 Oct 2018 08:27:31 GMT

Hello thanks for the tip. How do I synchronize the filters for the different pages?

Re: Hide filter pane on Embedded report

sulli01 — Tue, 16 Oct 2018 13:24:19 GMT

Using the top ribbon click 'View', then tick the box 'sync slicers'. This enables the slicer toolbar on the right.

Re: Hide filter pane on Embedded report

Arnaud_R — Wed, 17 Oct 2018 14:03:28 GMT

Hello,

In the view menu, select the synchronization panel 'Sync slicers'

Click on the filter in the future hidden page

Click in the synchronisation panel in the left column (Synchronize) on all the pages to remote.

Click on the right column (filter visible) only for the future hidden page

Re: Hide filter pane on Embedded report

Arnaud_R — Fri, 19 Oct 2018 07:54:19 GMT

Hi,

Not sure to understand the scenario:

- hide the filter page on the report (the owner can still see it anyway)

- show filter page and filter ???

Can you please explain again ?

Arnaud

Re: Hide filter pane on Embedded report

Anonymous — Thu, 02 May 2019 19:18:42 GMT

New article published, for Power BI Desktop. Please follow steps mentioned in the article.

https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview

Re: Hide filter pane on Embedded report

Anonymous — Tue, 07 May 2019 12:11:36 GMT

Can't this thread be merged together with https://community.powerbi.com/t5/Report-Server/How-to-hide-Filters-panel-in-power-bi-report-server-url/ ?

Re: Hide filter pane on Embedded report

sheetalshettiga — Thu, 23 Jan 2020 08:55:15 GMT

does any one have update on to hide filterpane in embedded report server

@muchinski