Power BI REST API Connection - Python Syntax

[PowerBI4Life]

Hi!

I went through the process of registering an app in in Azure AD.  I now have an Application (client) ID, Directory (tenant) ID, etc. 

The next step I would like to do is connect to the Power BI REST API.

Does anyone know what the python syntax would be to do this?  Or, have an example I could  use as a reference? 

Thank you in advance!

[ichavarria · Accepted solution]

Hi @PowerBI4Life,

I thinks this blog might help you: Monitoring Power BI using REST APIs from Python — DATA GOBLINS (data-goblins.com).

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.

[PowerBI4Life]

@ichavarria thank you for this article!  This is very helpful. 
...do you know if you have to be a global PBI admin for this to work?  Or, maybe the global PBI Admin could add the permissions to the Azure Security Group?

[ichavarria]

Hi @PowerBI4Life,

When authenticating with Service Principal, you are not using your user permissions, but the ones from the Service Principal. Therefore, you just need to configure the API permissions in the App Registration you create in Azure. Make sure to select the "Application permissions" (Delegated will only work if you are authenticating via a Master User. In the API Permissions (Application Permissions) you will see two, one who can read and write and another just for reading content, select the one that suits you better, usually the best option is tenant.read.writeall as it will also allow you to make POST and PUSH operations. 

Hope this helps!

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.