Power BI API Service Principal Account

Only for developers: how to create a service principal account to be used with the Power BI API.

00:00 Presentation
01:00 Description of the demo: an application pushes data in real-time onto a dataset. We already have the code of the application, but we need the authentication token for the service principal account of the application.
04:40 Description of the access token required
05:00 Registering the application in Azure Active Directory
07:10 Retrieving the Client ID to use in the authentication API
08:14 Retrieving the Tenant ID to use in the authentication API
08:45 Creating and retrieving the Client Secret to use in the authentication API
11:25 Setting the API permission for the application in Azure Active Directory
16:09 Introduction to MSAL (Microsoft Authentication Library)
17:29 Introducing the code to obtain the access token
18:09 Using the ConfidentialClientiApplicationBuilder class
18:53 Recap of how to use Client ID, Tenant ID, and Client Secret in the code
19:52 Declaring permission scopes required in the access token
21:20 Recap of permission scopes required by Power BI API
23:47 Sending the request and acquiring the token
25:40 First run of the application; description of the access token content and its caching.
29:08 Final demo, report updated in real-time!

[TomH]

I'd give this 10 stars if I could. Fantastic and finally one place to go to to complete everything.

[avinashkhatri]

Amazing tutorial! Kudos to content creator, if faced same problem with token generation and you killed it with explaning in detail . 12 out of 10 points :)

[SomeGuyInBrisVegas]

As always, absolutely fantastic. Thanks so much for making these lessons.

[muralichiyan]

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

[dariush]

I have to add my 100 Euros to the last comment, very good tutorial and you saved me a lot of time waste! grandi ragazzi!

[anmfaisal]

Great tutorial. Thanks a lot . My question is when we delegate access for end users and it can be a case of row level security- how can we get the end users setup the application? Any chance you have a vdo on that!!

[nikhilev]

Great Video. I am new to power Bi. Can you make a video on how to do table partitioning using Service Principal Account?

[Marcel-dtdu]

Thanks for this, much appreciated. Still, I hate that application permissions are all-or-nothing. It would make sense to be able to scope access to specific PBI workspaces.

[Atgether]

Hi, Thank you for this tutorial. Could you please tell if Tenant.Read.all application permission is enough if i will call exportToFile Api to export powerbi paginated report from one of the premium workspace?

[neehargadam]

Clear Explanation. I'm able to get the Access token but not able to fetch the data (ex: get all workspaces). Please help

[mcscunha]

EXCELENT!... I love this tutorial. It helps me too much! It was I needed. Thank you very much.

[abhradeepdas]

Hi I am working on a similar kind of project on python, I am trying access few apis like Power BI REST API to fetch all Groups and fetch all reports, somehow the api to fetch all groups seems to work fine but the api for fetching all reports is ending up in a 403 error. I am stuck on it for quite a few days.

[Bharath_PBI]

Thank you for the video 👍 Look like SQLBI gets external users to view some reports 🙂 through embed app.

[sergiomurru]

Very interesting video! Thank you Marco and Paolo

[kutz]

Thankyou Marco for the video. I have a overview report with URL to paginated report with all the details. In the URL I am passing the link to paginated and the parameters(filter selections on my Overview report). This is working but loading/rendering of paginated report is taking time, after it loads user exports the data to excel. Requirement is avoid rendering and get data directly in excel - I think possible solution is to create a Web App and use "ExportTFile" Rest API. If you have any suggestion on the C# code please let me know.

[pro]

Thanks for this tutorial! unfortunately i faced an annoying issue that i can´t solve, I was able to create an instance of ConfidentialClientApplication class, but i get an error " AADSTS50076: you must use multi-factor authentication to access", i don´t know how to solve... Any ideias would be great!!

[pritichaudhari]

Hello,

Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

[thalialoiola]

amazing tutorial! I loved it. Thanks for the video. Just one question: Is there any difference between getting token with MSAL or with another library? I'm using python (requests library) and I'm having trouble accessing admin APIs as a service principal. Thanks!

[SalmanKhan-olsm]

Hi Marco. I followed all your steps properly and try to get all groups as admin with the access token obtained. But I am getting What may be the reason?

[dhawalpmehta]

Why you are not using the Power BI Tenant setting to provide the permission for the Service Principal in Power BI instead of providing the API permission in the App Registration?