Connect to Power BI API via Python

[balwats88]

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

[Watsky · Accepted solution]

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/ 

[balwats88]

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

[Watsky]

Hey @balwats88,

Take a look at 

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

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