USE PYTHON TO GET DATA FROM POWER BI APIs

…such as limited dataset refresh history for datasets a service principle has access to

IN THIS ARTICLE

  • Get Dataset Refresh History from Power BI Admin API using Python Note: This is limited to the last 7 days or 60 refreshes, per dataset! If you want a long-running refresh history, you need to employ other methods, such as Azure Log Analytics, another endpoint, etc.
Example result dataframe for dataset refreshes obtained with the Admin API. The result is not a fully normalized dataframe, yet.
Example result dataframe for dataset refreshes obtained with the Admin API. The result is not a fully normalized dataframe, yet.

HOW TO SET IT UP?

I wrote a post about setting up a Service Principal, permissions & settings to get you started, as well as explaining the Authentication. You can find that post, here.

Code is provided as-is with no guarantees or warranties of any kind. Something I did quickly in spare time.