The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have followed the instructions in Microsoft's Embed a Power BI report on a form and have embeded my report with contextual filtering. The filter pane shows on the right side and I would like it hidden. How do I do that? The screenshot shown by Microsoft does not seem to have a filter pane displayed:
My report is created in Power BI Desktop and published to Power BI Service. The following filter-related settings in Report Settings are off (not checked): "Allow users to change filter types" and "Enable search for the filter pane"
I also tried adding displaySettings->isHiddenInViewMode=true to the <PowerBIFilter> parameter (see below), which loads without error but the filter pane is still displayed in my model-driven app.
<parameters>
<PowerBIGroupId>XXXXX</PowerBIGroupId>
<PowerBIReportId>YYYYY</PowerBIReportId>
<TileUrl>https://app.powerbi.com/reportEmbed?reportId=YYYYY</TileUrl>
<PowerBIFilter>{"Filter": "[{\"$schema\":\"basic\",
\"target\":{\"table\":\"Customers\",\"column\":\"Account\"},
\"operator\":\"In\",\"values\":[$a],
\"filterType\":1,
\"displaySettings?\":{\"isHiddenInViewMode?\":true}}]",
"Alias": {"$a": "name"}}</PowerBIFilter>
</parameters>
Is there a way to hide the filter pane when embedding a power bi report using this technique? Any suggestion for a better way to accomplish this?
Thank you,
Lyn
Solved! Go to Solution.
Ugh. Answering my own question for anyone who might have the same question.
I found the 'Show or hide the filter pane from report readers' eyeball while editing the report in Power BI Desktop. Turned that off and filter pane is hidden.
Ugh. Answering my own question for anyone who might have the same question.
I found the 'Show or hide the filter pane from report readers' eyeball while editing the report in Power BI Desktop. Turned that off and filter pane is hidden.