Power BI API Service Principal Account

[@TomH364]

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

[@avinashkhatri1986]

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 :)

[@muralichiyan]

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

[@dariush7272]

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!

[@anmfaisal964]

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!!

[@neehargadam1613]

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

[@Marcel-dt5du]

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.

[@Mgiusto]

If the Service Principle account isn't a member of the PBI Workspace, doesn't that give you the limits you're seeking?

[@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?

[@sergiomurru5055]

Very interesting video! Thank you Marco and Paolo

[@frenamakenson9844]

thx for sharing

[@chadd_robertson]

This is a brilliant video. Thank you.

[@Bharath_PBI]

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

[@nikhilev5180]

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

[@mcscunha]

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

[@26263kutz]

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.

[@thalialoiola1911]

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!

[@SQLBI]

It should be good as well, as long as it is provided by Active Directory.

[@davepoleon]

Top class!...thank you.

[@pritichaudhari7596]

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.

[@SalmanKhan-ol4sm]

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 "PowerBINotAuthorizedException". What may be the reason?

[@SQLBI]

Check if the service principal is enabled: docs.microsoft.com/en-us/power-bi/admin/service-premium-service-principal Manipulation of XMLA endpoint is not allowed to service principal in Power BI Premium per User (you need capacity), but this shouldn't affect the ability to user Power BI REST API.

[@MrWLKNSN]

This is for push datasets only. Is there a way to combine this with a normal dataset?

[@marcorusso7472]

The goal of the video is to explain the authentication required to access the Power BI API. The push dataset is just an example. With XMLA endpoint you can use the TOM API to add rows to an existing partition. As of today, this is not possible in Power BI Pro because it doesn't expose the XMLA endpoint.

[@MrWLKNSN]

@@marcorusso7472 reply well appreciated! Will check tom api Thx

[@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?

[@SQLBI]

I'm not sure what you mean - the Power BI tenant setting is required (and it is active) but it is not enough to complete the permission required in this example.

[@dhawalpmehta]

@@SQLBI ohh ok, sorry I misunderstood it as somehow I didn't remember seeing that in the video. Thanks for your confirmation and all the videos. :)

[@pro1427]

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!!