Awesome Open Source
Awesome Open Source


Big thank you to for contributing to this repo!

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API.

The goal of this connector is to enable you as an end-user or a tenant admin to easily:

  • Create a catalogue of all the resources deployed to your tenant
    • Dashboards
    • Reports
    • Datasets
    • Dataflows
    • Gateways
  • Retrieve a list of the members and types of access for each member inside an app workspace 'aka' Group
  • Analyze Refresh history and error codes Power BI REST API Connector

Some API end points perform poorly on large tenants, and as such we have included those in an "Experimental" folder as we cannot guarantee performance of these queries.

Power BI REST API Documentation

Be sure to read the official documentation from Microsoft about the Power BI REST API on:

To use the custom connector

You can grab the .mez file from this link and place it in your Power BI custom connectors folder. No other setup is required. You should be able to see the Power BI API Custom Connector in your Get Data Window:

Power BI API Custom Connector in Get Data window

For more information on how to create your own custom connectors folder, please visit the official documentation from Microsoft Power BI Custom Connectors.

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Api (22,117
Rest (4,129
Custom (828
Connector (346
Power (310
M (304
Related Projects