Hiding Report Level filters in the Iframe

[Mounika]

We published reports in power bi service. We have requirement to show only specific reports to user.So we created a table and configured user, reports to be shown.We need to display those reports in ASP.Net web application. We are embeding the reports in a n iframe.We are passing the user name as parameter form web application to powerbi service and fetching the reports of that specific user. But on clicking over Filters pane we are able to select the other users from that table. Is there any possibility to hide the report level filters while developing the power bi reports?

[NellyRamachand]

Hi, I found a solution to this problem. You will need to go to File, Select Options & Settings, click into: Options > Report Settings and tick 'Filtering Experience' and then click 'OK'. After you have done this, you will notice that an icon looking like an eye appears next to the words 'FIlters' on the filtering pane. Hope this helps 🙂

[Eric_Zhang]

@Mounika

You can hide the filter panel by appending a parameter to the embed url, eg

https://msit.powerbi.com/reportEmbed?reportId=1ac729a0-1f64-4b32-a32e-d5xxxxxxx019&filterPaneEnabled=false

[Mounika]

I need to pass a parameter to powerbi service as well as this filter how can we achieve this? Also I need to hide only Report level filters by doing this will the visualization filter will also be hidden?

Ex: Appending parameters to href parameter

 href + "&$filterPaneEnabled=false&$filter=Query2/Name eq 'Type2'

the above is not working can you suggest proper way ? Also solution for hiding only report level filters

[Eric_Zhang]

@Mounika

So far, AFAIK, there's no way to hide only the report level filter, you can hide the whole filter panel or non.

[Mounika]

Ok fine. Then can we pass multiple parameters to power bi service ?

[Eric_Zhang · Accepted solution]

@Mounika

In your case, try to append below string, no $ before filterPaneEnabled. Based on my test, it works.

&filterPaneEnabled=false&$filter=Query2/Name eq 'Type2'

[ozandikerler]

In my case, my iframe address is;

<iframe
src="http://bntnetsreport/webportal/powerbi/new?rs:embed=true&filterPaneEnabled=false"
frameborder="0"
allowFullScreen="true">
</iframe>

But it doesn't work. Could you please help me?

[veeramohan_m]

Hi @Eric_Zhang,

I tried this but its not working for me. I am using an On-premise repeort server.

Kindly let me know what I am missing

Regards,

Mithra

[Greg_Deckler]

Well, since you are embedding this as an iframe in your own ASP.Net application, can you target the elements in the iframe with CSS or jquery?

http://stackoverflow.com/questions/6494721/css-override-body-style-for-content-in-iframe

[Mounika]

The content in the iframe is not in the same domain as the web application so we are unable to hide them.

[Greg_Deckler]

Ah yes, duh. I guess when I was remembering doing this for a customer, I was able to convince the third party to add a CSS reference in their page for my own CSS document and thus I was able to have 100% control over their page. Hmm, might make for a good Idea...

[veeramohan_m]

Hi @Greg_Deckler,

I am also looking for an option something like that, since I am doing a cross origin accessing where my web page is in a domain and my iframe is in another page. Kindly let me know what exactly I need to do get 100% access over the power BI report. In my case, I am using an on-premise Power BI report server and embedding a report in this server to web page. I am doing this to hide the filters pane and the navigation pane in web page.

Kindly let me know the possibilities.

Regards,

Mithra