Forum Discussion
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!
- Anonymous4 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 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);Best Regards
2 Replies
- AnonymousNot 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 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);Best Regards
- AnonymousNot applicable
Thanks a lot!