Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      Thanks a lot!