Skip to main content

How to Customize Iframes Embedded Power BI Reports in fabriq

Customize your Power BI embeds! Control which page loads, filter data automatically, and hide clutter for cleaner dashboards

Simona Ianniello avatar
Written by Simona Ianniello
Updated over 2 weeks ago

When you embed a Power BI report into your Fabriq dashboard, you can control:

  • Which page of the report appears first

  • What data shows (like a region or project)

  • Whether menus or filters are visible

This is done by adding options to the end of the Power BI link before you paste it into Fabriq, follow these steps to help you navigate it.


🖇️ Step 1: Get Your Power BI Embed Link

  1. In Power BI, open the report you want.

  2. Click File → Embed report → Website or portal.

  3. Copy the “link to embed this content” content in fabriq.

  4. The following screen appears if a user hasn't signed in to Power BI in their browser session. When they select Sign-In, a new browser window or tab should open. Have them check for pop-up blockers if they don't get prompted to sign in. If SSO is active for both your fabriq and PowerBI accounts, you won’t need to sign-in multiple times.

    Official Microsoft Documentation: How to embed Power BI reports into portals.


🧩 Step 2: Customize the Link

Now you'll add special options to the end of that link to control how it behaves inside Fabriq.

Every customization is added using an ampersand (&) followed by the setting. If you're adding more than one setting, just keep adding them one after the other with & between them.

Example:

...reportEmbed?reportId=abc123&groupId=xyz456&pageName=ReportSection1&filter=Region/Name eq 'North'&filterPaneEnabled=false

In this example:

  • &pageName=... sets which tab opens first

  • &filter=... limits what data appears

  • &filterPaneEnabled=false hides the filter pane

📃 Show a Specific Page

Every report has pages (tabs). If you want to show a specific one when the report loads:

  1. In Power BI, click the tab you want.

  2. Copy the pageName from the browser URL. It looks like this and you can use the screenshot below, as a reference:

    ReportSection9380eec50a2a0165bb4b

  3. Add that to your embed link:

    &pageName=ReportSection9380eec50a2a0165bb4b

👉 Example:

https://app.powerbi.com/reportEmbed?reportId=abc123&groupId=xyz456&pageName=ReportSection9380eec50a2a0165bb4b

📊 Show Only Specific Data (Filters)

You can filter your report to only show data that matters to you, like a certain region, department, or project.

  1. First, figure out:

    • The table name (like Region)

    • The field name (like Name)

    • The value you want to filter by (like 'North')

  2. Use this format:

    &filter=Table/Field eq 'Value'

👉 Example: To only see data for the North region, full link:

https://app.powerbi.com/reportEmbed?reportId=abc123&groupId=xyz456&pageName=ReportSection9380eec50a2a0165bb4b&filter=Region/Name eq 'North'

✅ Filter on More Than One Value in a Field

To filter on more than one value in a single field, use the in operator instead of multiple and statements.

Syntax:

&filter=Table/Field in ('value1', 'value2')

👉 Example:

To filter the report to show data only for stores in “NC” (North Carolina) or “TN” (Tennessee):

&filter=Store/Territory in ('NC', 'TN')

You can mix this with other filters for even more control — see the example below in the next section.

⚙️ Filter on Multiple Fields

You can also filter on multiple fields by combining them with and.

Example:

&filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

Example combining in and and:

 &filter=Store/Territory in ('NC', 'TN') and Store/Chain eq 'Fashions Direct'

See the Operators table in Microsoft documentation for a full list of supported operators.

💡Special Characters in Table and Column Names

When your table or column names contain spaces, dashes, leading numbers, or special characters, you’ll need to escape them in your filter using a special code format.

Prefix the special character with _x, followed by its four-digit Unicode, then another underscore.

Identifier

Unicode

Power BI Encoding

Space

00x20

_x0020_

@

00x40

_x0040_

Examples:

Original Name

Encoded Name

Table Name

Table_x0020_Name

Column@Number

Column_x0040_Number

📘 Learn more:

For a complete list of supported escape codes and URL filter syntax, see Filter a report using query string parameters in the URL (Microsoft Docs).


🎨 Hide Menus and Side Panels

You can clean up how the report looks inside Fabriq by hiding Power BI’s panels.

Want to hide this?

Add this to your link

Side page list (tabs)

&navContentPaneEnabled=false

Filters panel

&filterPaneEnabled=false

Top toolbar

&actionBarEnabled=false

👉 Example with all 3:

https://app.powerbi.com/reportEmbed?reportId=abc123&groupId=xyz456&pageName=ReportSection9380eec50a2a0165bb4b&filter=Region/Name eq 'North'&navContentPaneEnabled=false&filterPaneEnabled=false&actionBarEnabled=false

Limitations: Showing a Single Visual (Tile)

Unfortunately, due to Power BI limitations, you can only embed entire pages (tabs), not individual visuals.

The closest workaround is to:

  • Create a dedicated page with just the visual you want.

  • Embed that specific page using the &pageName= parameter as explained above

Official Microsoft Documentation:


🌐 Browser Compatibility

Some embed issues are caused by browser limitations.

  • ✅ Microsoft Edge and the latest Chrome are most reliable

  • ❌ Internet Explorer is not supported

  • 🔄 Test in the same browser your users will use


📘 Learn More

If you want to explore the official Microsoft documentation:

Did this answer your question?