Getting Started With Power BI API (Set Up, Configuration, Examples)

In this tutorial, I will walk you through how to start using Power BI REST API using Python.

The Power BI REST API provides service endpoints for your programming language to directly connect to Power BI API Service, from there you can manage your Power BI content, perform admin operations, embed Power BI Content on the web, or ETL automation.

▶ Power BI API Resources
-----------------------------------------------------------------------------------------

▶ Buy Me a Coffee? Your support is much appreciated!
-----------------------------------------------------------------------------------------
🔑 Venmo: @Jie-Jenn

▶ Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

⌚ Timestamp
00:00 - Intro & Agenda
01:21 - Go Through Power BI App Registration Tool
04:10 - Review Power BI App in Azure's Portal
04:48 - Modify Power BI App settings
05:50 - Dive into Python script
09:33 - Generate Access Token
13:40 - Run an example

#PowerBI #PowerBIAPI

[tameimpalan]

Freaking amazing video man! Just an advice do the ones that are starting on python... I couldn't set the cred.py file, nor install the package, so i just created the variable with username and password. It's not the best practice to do, but it worked properly, so let the future me worry about secury stuff lol.

[MohamedAslamK-mhwn]

Wonderful video its work to me, but at the same in my side *Disable Default Security* option not necessary to me just apply *<Grand Permission>* is enough to me and its work...!, once again thank you so much...

[JorgeEscobarMX]

Thank you. Great content and now I see how to connect Python to a power bi dataset.
I wonder if you can query a power bi dataset as if it is a database?

[majidabbasi]

thank you for an amazing and detailed video.

[tetzki]

thanks this is helpful. is there a way get query a power bi dataset using this python script?

[gifbfbvhvhdhfhfjffjfnfhfb]

Thank you so much the azure kept returning error 401 and what was missing was turning the azure active directory security off

[milpatel]

For companies who use Power BI via an Office 365 licence, I assume the setting changes made in Azure would need to come via the IT department?

[jcarneiro]

Doesn't let me disable security defaults, a permission related message prompts

[muralichiyan]

Nice keep rocking …
We need to buy azure embedded licenses for this ..?

[vtrg]

Hi!! Can you explain how get the access token with a service principal authentication??

[navinrangar]

Hi man,
awesome this is.
how can we refresh this access token automatically hereafter?

[jaroslavmarko]

Hi, thank you for perfect and detailed video.
Maybe you can help me with one issue. I fail to authenticate using username and password (I get an "The access policy does not allow token issuance." - which should mean that I need to use MFA - company policy that cannot be avoided). When I use Confidential client then i can get a Access token, but it gets refused by the http call (401 error).
Any idea how can I perform a MFA authentication and get a functional token, please? Thanks a lot for your answer.

[MHFCLoveOfMyLife]

Hey :)
Thanks for the detailed video!!
When trying to register application I get this error:
Error when registering application: ERROR: Request returned Forbidden and graph API request id: {id}
Do you know what can be the problem?
thanks!

[hxqbiij]

Is there any additional costs when running requests to API when using pro account?

[MHFCLoveOfMyLife]

Hey,
If i don't own pbi pro, and my co worker is creating the app our team use, can i use his app client id and secret with my user, in my code, in order to fetch data from the api? will i'll be able to create access token?

[andresmoreno]

I am trying with MSAL ConfidentialClientApplication, I am getting the token correctly, but the last part is not working for me...
Do I need to change the way I build my endpoint?
Or How I know which is my endpoint?

Hope you could solve my doubt c:

[ztnnmbn]

can I have the same implementation code with java

[ricardojosemunozanaya]

hello bro, i dont know what happened, "ValueError: Public Client should not possess credentials"

[MHFCLoveOfMyLife]

Hey,
Can I use the api without pbi pro?

[morinho]

Hello, when I check the reponse to the access token, I see that the scope returned in my access token is and not the actual scopes defined in the app.
Do you have any idea why ?

Thanks a lot !!