Power BI Embedded ISV - Hyperlink incl. Filters to target page

[Anonymous]

Hi Community! 

I am looking for help with the following scenario: 

We are building a software solution on AWS for our client, our reports will be embedded in this ISV. 

The requirement for one of the reports is to include a link to one of the pages of the software, but already filtered by the selected filters in the embedded report. 

So for example: 

I have a table in my embedded report showing contracts of all my customers.

I select customer A and year 2021 in my filters. The link provided in the table should change dynamically AND filter the target page in the software to customer A and year 2021. 

Could somebody please tell me if and how this can be done? 

Thanks in advance! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer the following blogs to get it.

POWER BI URL FILTERS MADE EASY

https://app.powerbi.com/reportEmbed?reportId=787a839b-dec4-4e26-a063-be49fcf18879&autoAuth=true&filterPanelEnabled=False&pageName=ReportSectionc33aa21606003eda9841&$filter=Netflix/Genre in (‘Documentary’,’Drama’)

Embed iFrame filtering

Embed your Power BI report with predefined filters

const filter = {
        $schema: "http://powerbi.com/product/schema#basic",
        target: {
            table: "DimProduct",
            column: "ColorName"
        },
        operator: "In",
        values: ["Silver"]
    };
var config = {
              type: 'report',
              tokenType: models.TokenType.Embed,
              accessToken: accessToken,
              embedUrl: embedUrl,
              id: embedReportId,
              permissions: models.Permissions.All,
              filters: [filter],
              settings: {
                            filterPaneEnabled: true,
                            navContentPaneEnabled: true
              }
};
// Embed the report and display it within the div container.
var report = powerbi.embed(reportContainer, config);

Control report filters

Best Regards

[Anonymous]

Thanks a lot!