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

Hide filter pane on Embedded report

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Hide filter pane on Embedded report

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
18 REPLIES 18
v-yulgu-msft Super Contributor
Super Contributor

Re: Hide filter pane on Embedded report

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nchambe Regular Visitor
Regular Visitor

Re: Hide filter pane on Embedded report

Any update on this possibility for report server?

SWOS Regular Visitor
Regular Visitor

Re: Hide filter pane on Embedded report

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.

karthikvalluri Regular Visitor
Regular Visitor

Re: Hide filter pane on Embedded report

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

sysadm01 Frequent Visitor
Frequent Visitor

Re: Hide filter pane on Embedded report

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>

 

karthikvalluri Regular Visitor
Regular Visitor

Re: Hide filter pane on Embedded report

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.

sysadm01 Frequent Visitor
Frequent Visitor

Re: Hide filter pane on Embedded report


@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.

dpombal Member
Member

Re: Hide filter pane on Embedded report

Any update on this feature¿

sulli01 Frequent Visitor
Frequent Visitor

Re: Hide filter pane on Embedded report

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!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 102 members 1,660 guests
Please welcome our newest community members: