Skip to content

Power BI API

Tldr

The Power BI API allows you to automate Power BI tasks and to access data.
You need at least a PPU user.
If you want to automate batch creation of reports, you will need an Embed capacity.
Authentication and other frequent tasks are wrapped in our py-powerbi library.

References

The Power BI API lets you automate tasks such as:

  • refresh dataset

  • export paginated report

  • fetch data

  • etc.

Authentication

You authenticate via an Entra App. You can use both the authorization code flow or the client credentials flow.

Personal Mode (User owns data) vs Embed token (App owns data)

There are two modes.

The Power BI Proxy typically uses the Personal Mode. However, note that we still require an Embedded capacity, as with a PPU user, you can only export a report once every 5 minutes.