power-bi-embedded-reports-reactive
Reactive icon

Power BI Embedded Reports (Reactive)

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded
 on 23 May 2023
 by 
0.0
 (0 ratings)
power-bi-embedded-reports-reactive

Power BI Embedded Reports (Reactive)

Documentation
1.0.0

URL FIlter Generator

The Test Reports Screen now has a URL Filter Generator popup that will help the user build URL filters.

Just add the desired filters and click on Generate and Send to Screen. The generated filter will be automatically populated in the Parameters input.


Get Filters (Console)

This link will print in the developer tools console the current state of the report filters.

Parse Filter Array

This will let you add a filter array to your report. Make sure you pass a Filter Array in a correct JSON format, click on Parse Filter and then on Apply Filter. The filters will be applied to your embedded report.

The report must be loaded before using these actions.


Parse Slicer State

This will let you change a slicer state in your report. Make sure you pass the Slicer Visual Name and Slicer State in the correct JSON format, click on Parse State and then on Apply Slicer State. The slicer in your report will be updated.

The report must be rendered, and the visual must be in the active page before using these actions.


0.1.1
  • No changes from 0.1.0.

0.1.0

Setup a Service Principal as shown in this guide: Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Learn 

Open the ServicePrincipalSettings screen and add the required paramenters:

Open the Reports screen and add the reports you want to embed:

Add a report name, the Embed URL, the report GUID and at least a Dataset and a Report.

*Note: The Main Report GUID should also be included in the "Reports" or the "Effective Identities" section depending on your report.

Once a report is added, you can test it on the TestReports Screen:

The parameters section takes the report filters as shown in Filter a report using query string parameters in the URL - Power BI | Microsoft Learn or URL parameters in paginated reports in Power BI - Power BI | Microsoft Learn 

To embed a report in a different app/screen, use the EmbeddedReportBlock, which takes a PowerBIReportId as an input. The PowerBIReport table is public so you can retrieve report names and Ids.