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|
|Free Form||Responsive Form||Mobile|
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.
Width: Determines the width of the report component on the form. Write in px, ie.: 300.
SQL Query: Five different arguments are needed to be supplied to embed Power BI reports in your forms. These are:
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.