Integrating PowerBI and QlikView reports

From PegaWiki
This is the approved revision of this page, as well as being the most recent.
Jump to navigation Jump to search



Description Emedding external web-based BI/analytic tools such as PowerBI and QlikView into a user's dashboard
Version as of 8.5
Application Platform
Capability/Industry Area User Interface



Some customers may have existing investments in Business Intelligence and Analytic tools, such as Microsoft PowerBI or QlikView. Users may rely on data and visualization from these systems, and want them on their Pega dashboard instead of switching to a different browser tab. Alternatively, other users may want to use BIX to export data from Pega Platform applications, build reports and visualizations elsewhere, and then embed said reports in Pega Platform applications.

This design pattern describes how to create a control in Pega Platform that contains an embedded report, using an iframe tag.

Creating a new control[edit]

  1. In the header of Dev Studio, click Create > User Interface > Control.
  2. Select an appropriate label and ruleset.
  3. Clear the Auto-generated check box.
  4. In the HTML SOURCE field, paste the following HTML:
<iframe width="<pega:reference name="Param.Width" />px"
       height="<pega:reference name="Param.Height" />px" 
       allowfullscreen="true" 
       src="<pega:reference name="Param.ExternalURL" />">
</iframe>

5. Select the Show in authoring menus check box.

6. In the Category field, select Data Display

7. Optional: In the Control image field, enter the path to a graphic file that you want to use as a control image.

Pega-control-iframe.jpg

8. On the Parameters tab, create the following three parameters:

  • Height, Integer
  • Width, Integer
  • ExternalURL, String

9. Click Save, and then justify the guardrail warning.

Pega-control-iframe-parameters.jpg

Creating a dashboard widget[edit]

  1. In the header of Dev Studio, click Create > User Interface > Section.
  2. Select an appropriate label and context.
  3. Convert the section to a full section - this is required for a dashboard widget.
  4. Drag and drop the newly created control to your section.

Creating a dashboard widget.jpg

5. Double-click the control to bring up the Cell properties dialog box.

6. Enter the values that you want to use in the Height, Width, and ExternalURL fields.

Report-widget-parameters.jpg

Note: For testing purposes, use the following URL. The double quotation marks are required:

"https://app.powerbi.com/view?r=eyJrIjoiYjA1YzhhMjItMWU1ZS00YmRiLWI3MjUtZDVhN2ZlMzY4NjFlIiwidCI6IjJjOTJmZjI0LWI0MmMtNDgwZC1iNzRkLTY2ZmNlNzZiZDdkYSIsImMiOjl9"

7. Click Submit, and then click the Settings tab.

8. Select Dashboard widget and enter an appropriate name and category, then click Save.

Report-widget-settings.jpg

9. Launch your user portal and switch to your dashboard. Click the Settings icon in the upper-right corner to edit the dashboard.

10. Click Add widget(s), select the PowerBI Example widget, and then click Add selected.

Adding-power-bi-widget.jpg

11. To publish the dashboard, click Publish. The widget is now fully interactive.

Note![edit]

The widget's properties can be exposed to the end user, even if you don't want them to be. For more information, see Settings tab of the Section form on Pega Community.