Forum Discussion

amassip's avatar
amassip
Helper I
9 years ago

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

Need Help

13 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi amassip,

     

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

     

    Best Regards,
    Qiuyun Yu

    • rpatkar's avatar
      rpatkar
      Power BI Team
      9 years ago

      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's avatar
        Markkeny
        Frequent Visitor
        9 years ago
        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
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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

     

    • Markkeny's avatar
      Markkeny
      Frequent Visitor
      9 years ago

      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's avatar
        Markkeny
        Frequent Visitor
        8 years ago

        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

    • mstacey's avatar
      mstacey
      Advocate I
      8 years ago

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