Microsoft Power BI
  • 15 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Microsoft Power BI

  • Dark
    Light
  • PDF

Article summary

Microsoft Power BI is a business analytics tool for visualizing and sharing data insights across an organization.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Users
  • Groups
  • Compute Services

Parameters

  1. Azure Client ID, Azure Client Secret, Azure Tenant ID, Cloud Environment (required) - See details under Microsoft Entra ID.

  2. Azure Oauth Authorization Code (Optional) - The authorization code to connect to Microsoft Intune. For more information see Generate the OAuth Authorization Code.

  3. Azure OAuth - Redirect URI/Reply URL - The location where the authorization server sends the user once the Azure has been successfully authorized and granted an authorization code or an access token. For more information, see Redirect URI (reply URL) restrictions and limitations.

  4. Microsoft Username and Microsoft Password (required) - This option is available when you choose 'User Name and Password' as the Authentication Method. The credentials for a Microsoft user account that has the Required Permissions to fetch assets.

  5. API Type (default: Commercial) - Select the API type. When a government entity is selected, the data is sent to app.powerbigov.us for government use instead of app.powerbi.com.

  6. Verify SSL - Select whether to verify the SSL certificate of the server against the CA database inside of Axonius. For more details, see SSL Trust & CA Settings.

  7. HTTPS Proxy (optional) - Connect the adapter to a proxy instead of directly connecting it to the domain.

  8. HTTPS Proxy User Name (optional) - The user name to use when connecting to the value supplied in Host Name or IP Address via the value supplied in HTTPS Proxy.

  9. HTTPS Proxy Password (optional) - The password to use when connecting to the server using the HTTPS Proxy.

To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.

PowerBI_Adapter1

Generate the OAuth Authorization Code

If you are authenticating with OAuth, you’ll need to generate an OAuth Authorization Code for this adapter setup.

Generate the OAuth Authorization Code

  1. Copy and Paste the following URL into a browser window. Make sure to add the Tenant ID, Client ID and Redirect URI that you used earlier in this setup and save the URL for later use:
    https://login.microsoftonline.com/TENANT/oauth2/v2.0/authorize?client_id=CLIENT_ID&scope=https://graph.microsoft.com/.default&redirect_uri=REDIRECT_URI&response_mode=query&response_type=code

  2. Authorize, if required.

  3. Copy the value for the code parameter in the changed URL. This is the entire string in the URL between code= and &session_state and it can be quite long.
    AuthorizationCodeParameter

  4. Back in Axonius, paste the copied code into the Azure OAuth Authorization Code field.
    Get the redirect URL:

    1. In Microsoft Azure, Navigate to App Registrations and select your application for this integration.
    2. On the left-panel, navigate to Manage > Authentication.
    3. In the Web area, copy one of the redirect URIs.
    4. Back in Axonius, paste the copied Redirect URI into the Azure OAuth - Redirect URI/Reply URL field.
      RedirectURI1

APIs

Axonius uses the following APIs:

Required Permissions

  • To connect with delegated permissions, you must register an Entra ID application with Power BI.
  • The application requires the following Delegated permissions: Power BI Service: Dataflow.Read.All and Workspace.Read.All.

PowerBI_Permissions

Supported From Version

Supported from Axonius version 6.1



Was this article helpful?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
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.