topic Re: Connect to Power BI API via Python in Developer

Connect to Power BI API via Python

balwats88 — Wed, 26 Jan 2022 09:24:22 GMT

Hi, I need to connect to Power BI API via Python. What should I do to accomplish it? I'd like to pull data from my organization work spaces. Please help me. All information that I found telling me that I have to create Azure AD, than generate token and etc.. Is it another, easier way? Thank you so much

Re: Connect to Power BI API via Python

Watsky — Wed, 26 Jan 2022 23:26:53 GMT

Hi @balwats88 ,

There isn't a way around the steps you mentioned. Registering an app through Azure AD is required to access the REST API.

To use the Power BI REST APIs, you need to register an Azure Active Directory (Azure AD) application in Azure. The Azure AD app establishes permissions for Power BI REST resources, and allows access to the Power BI REST APIs.

https://docs.microsoft.com/en-us/rest/api/power-bi/

Re: Connect to Power BI API via Python

balwats88 — Tue, 01 Feb 2022 09:41:21 GMT

Thank you! And also, could you, please, send me template of Python script which I should use?

Re: Connect to Power BI API via Python

Watsky — Tue, 01 Feb 2022 14:31:13 GMT

Hey @balwats88,

Take a look at

GitHub - AntoineDW/powerbi-rest-api-python: A Python library created to easily use the Power BI REST API with Python

GitHub - areed1192/power-bi-python-api: The Unofficial Python API wrapper for the Microsoft Power BI REST API.