Microsoft Power Bi

​

Overview

​

Pre-built tooling

​

Pre-built integrations

No pre-built integration yet (time to contribute: <48h)

​

Access requirements

​

Setup guide

No setup guide yet.

​

Useful links

• How to register an Application
• OAuth related docs
• Microsoft Power Bi REST API docs

​

API gotchas

• You can find scopes required for each API call in their corresponding API calls section. For example, to retrieve a list of datasets from My workspace, you can refer to the Required scope section of the Get Datasets documentation. You also need to prepend the hostname to the scope, which in the get datasets example would be https://analysis.windows.net/powerbi/api/Dataset.ReadWrite.All. For more details, check this resource out.
• Please be aware that the Microsoft Power Bi implements throttling to manage the volume of requests. For more information on handling throttling, refer to the Microsoft Power Bi Throttling Guidance.
• If you are developing an app for users within your own organization and the app has already been granted adequate permissions at the organization level with user consent turned off, you must override the integration config when calling the create connect session method:
  • Override authorization_params by setting only scope: '.default' and "prompt": "" to remove the consent screen. Note that if consent is required it will prompt the user for consent due to the “.default” scope.
  • Override authorization_params by setting only scope: '.default offline_access' and "prompt": "" to remove the consent screen. Note that if consent is required it will prompt the user for consent due to the “.default” scope.
  • Set the .default scope documentation to ensure the permissions remain the same as those granted at the organization level.

const { data } = await nango.createConnectSession({
  [...],
  integrations_config_defaults: {
    "microsoft-power-bi": {
      authorization_params: {
        scope: '.default offline_access',
        "prompt": ""
      }
    }
  }
});

If this is not done, the app will show a consent screen prompting the user to grant permissions which the user will be unable to do without admin access.