In this post I explain how to call the Power BI REST APIs from Python. You can do this either with a dedicated user or a Service Principal registered from the Azure Portal. I’ll walk through the necessary steps to get this working.
All tagged Python
In this post I explain how to call the Power BI REST APIs from Python. You can do this either with a dedicated user or a Service Principal registered from the Azure Portal. I’ll walk through the necessary steps to get this working.
It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports. Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple measures in a Power BI report, including those used in “broken” visuals. Fix all broken visuals in Power BI reports using this method!
In this post I explain how to get dataset refresh history from Power BI using Python. For this method, you need to be a tenant Admin, and it is limited to only 7 days or 60 refreshes, per dataset. For more history, you need another API or method.
In this post I explain how to call the Power BI APIs from Python with a Service Principal to get all the publish-to-web and cross-org share links in your tenant, which pose a big governance risk.
In this post I explain how to call the Power BI APIs from Python with a Service Principal to get all the workspaces managed in your tenant. I share also a github gist for a Python script which retrieves all workspace objects, including users, datasets, reports, etc.
In this post I explain how to call the Power BI APIs from Python with a Service Principal to get the deployment pipelines managed in your tenant.
In this article, we look at how the report source control tool pbi-tools can be run in Python, and how to create a basic GUI in Python to support this.