Forum Discussion

muchinski's avatar
muchinski
Resolver II
8 years ago
Solved

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?

  • 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

22 Replies

  • sysadm01's avatar
    sysadm01
    Frequent Visitor

    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's avatar
      karthikvalluri
      Helper I

      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's avatar
        sysadm01
        Frequent Visitor

        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.

    • mpsrshl's avatar
      mpsrshl
      Advocate II

      This is cool thanks! just wondering if the same can be applied to the bottom tabs? 

       

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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

    • nchambe's avatar
      nchambe
      Advocate II

      Any update on this possibility for report server?

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.

    • sulli01's avatar
      sulli01
      Frequent Visitor

      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!

      • Arnaud_R's avatar
        Arnaud_R
        Helper II

        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.

    • karthikvalluri's avatar
      karthikvalluri
      Helper I

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    For those using this on PBI online do not the boolean value is case sensistive

     

    This 

    ?rs:Embed=True&filterPaneEnabled=False

    should be 

    ?rs:Embed=True&filterPaneEnabled=false
  • Possible turn around:
    - Create a new page
    - add the filters and synchronize them with all the pages of the report
    - hide this page

    • FrancoiseLB's avatar
      FrancoiseLB
      New Member

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

      • sulli01's avatar
        sulli01
        Frequent Visitor

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

  • 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 

    • Arnaud_R's avatar
      Arnaud_R
      Helper II

      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