Send Data to Microsoft Power BI
  • 25 May 2022
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Send Data to Microsoft Power BI

  • Dark
    Light
  • PDF

Send Data to Microsoft Power BI inserts the entities retrieved from the saved query supplied as a trigger (or entities selected in the asset table) to the Microsoft Power BI table supplied.
When used with a saved query as a trigger, only the fields configured in the saved query are inserted to the supplied table.

To configure the Send Data to Microsoft Power BI action, from the Action Library, click Notify, and then click Send Data to Microsoft Power BI.

Connection Settings

Click to view Connection Settings
  1. Azure Client ID (required) - The Application ID of the Axonius application, as detailed in the Required Permissions section.

  2. Azure Client Secret (required) - A user created key for the Axonius application, as detailed in the Required Permissions section.

  3. Microsoft Username and Microsoft Password (required) - Microsoft Account credentials.

  4. Group ID (optional) -Group ID in PowerBI.

  5. Dataset Name (required, default: AxoniusDataset) - the dataset name in PowerBI. In Power BI, click Datasets in the left pane.
    PowerBIDatasets_2

  6. Table Name (required, default: AxoniusTable) - the table name in PowerBI. Select a dataset and the tables in that dataset are listed below in Explore related reports.
    PowerBITables

    Notes:
    • If no table with the supplied name exists in the dataset, it will be created.
    • When a change is made to a table, the table is recreated with the new data (if any). Power BI does not have an Update Table function.
  7. Verify URL (required, default: False ) - Verify the SSL certificate offered by Power BI. For more details, see SSL Trust & CA Settings.

    • If enabled, the SSL certificate offered by the host will be verified against the CA database inside of Axonius. If it fails validation, the connection will fail with an error.
    • If disabled, the SSL certificate offered by the host will not be verified against the CA database inside of Axonius.
  8. HTTPS proxy (optional, default: empty) - A proxy to use when connecting to the server.

APIs

Click to view APIs

Axonius uses the Microsoft Power BI Rest API Push Dataset.

Required Permissions

Click to view Required Permissions

To connect to Microsoft Azure, you need to create a designated Axonius application in the Microsoft Azure Portal and grant it read-only permissions. All required credentials will be given once an application is created. For details, see Creating an application in the Microsoft Azure Portal.

In addition you need to Register an Azure AD application to use with Power BI.

Using Send Data to Microsoft Power BI action requires Dataset.ReadWrite.All access to devices.


To learn more about configuring Enforcement Sets, see Configuring Enforcement Sets.


First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.