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 :)
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?
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!!
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.
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.
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!
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?
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.
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!!
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.
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?
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.
