Power BI Report

With the Power BI® Report tool, you can embed your Microsoft Power BI® reports in your Xpoda forms and prepare rich dashboards. After designing your reports in the Power BI interface, drag them from the toolkit to your form.

Toolbox Appearance Free Form Appearance Responsive Form Appearance
Screenshot_2022-12-29_193719.png Screenshot_2022-12-29_193857.png Screenshot_2022-12-29_193840.png

 

Compatibility

Free Form Responsive Form Mobile
icons8-check-circle-48.png icons8-check-circle-48.png icons8-check-circle-48.png

 

 

Power BI Report Properties

Type: Indicates the field type of the added form tool. The value here cannot be changed.

Name (Field Name): The name of the component is written. It will be created automatically but can be changed.
Help Text: It is the text entered for the explanation to appear when the mouse is hovered over the form tool.

Height: Determines the height of the report component in the form. Write in px, ie.: 300

Width: Determines the width of the report component on the form. Write in px, ie.: 300.

From Left / Top: Determines the left and top position of the component.

blobid0.png

The Width and From Left / Top properties are only valid for forms of the Free Form type. In responsive usage, the component will automatically use the appropriate width and position.

SQL Query: Five different arguments are needed to be supplied to embed Power BI reports in your forms. These are:

  1. Application Id
  2. Report Id
  3. Workspace Id
  4. Application Secret
  5. Tenant Id

These values should be obtained from Microsoft Azure® and Power BI dashboard. To get these values, you can follow the link Embed Power BI report in a Power BI embedded analytics application for your customers - Power BI | Microsoft Learn


You can provide these values either by returning a constant value from your SQL query or by reading from the database. Do not forget that Application Secret information must be kept securely. You can provide data to the SQL query field as follows.

select '98cf3121-1332-4b35-ba73-081ff1a69ffx','AppId'
union
select 'e3e5270d-b531-4aa6-9542-322bd2111c12','WorkspaceId'
union
select '1072542e-d9b7-5617-acef-dddfce330557c','ReportId'
union
select 'b8Sjh2X~NTSCBX-Wxybp6cRGQVyf5QVkoPNB9CSKC','AppSecret'
union
select '65b7cb2f-c294-55fc-c04c-bc79c95c97e3','Tenant'


Note that the field names are AppId, WorkspaceId, ReportId, AppSecret and Tenant.The order of the data is not important.

blobid0.png

There is no action usage in the Power BI element!