Тёмный

Power BI API Service Principal Account 

SQLBI
Подписаться 110 тыс.
Просмотров 18 тыс.
50% 1

Опубликовано:

 

29 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 30   
@TomH364
@TomH364 3 года назад
I'd give this 10 stars if I could. Fantastic and finally one place to go to to complete everything.
@avinashkhatri1986
@avinashkhatri1986 2 года назад
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 :)
@neehargadam1613
@neehargadam1613 3 года назад
Clear Explanation. I'm able to get the Access token but not able to fetch the data (ex: get all workspaces). Please help
@muralichiyan
@muralichiyan 2 года назад
Nice keep rocking … We no need to buy azure embedded licenses for this right..?
@Atgether
@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?
@anmfaisal964
@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!!
@Marcel-dt5du
@Marcel-dt5du 2 года назад
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
@Mgiusto Год назад
If the Service Principle account isn't a member of the PBI Workspace, doesn't that give you the limits you're seeking?
@nikhilev5180
@nikhilev5180 3 года назад
Great Video. I am new to power Bi. Can you make a video on how to do table partitioning using Service Principal Account?
@Bharath_PBI
@Bharath_PBI 4 года назад
Thank you for the video 👍 Look like SQLBI gets external users to view some reports 🙂 through embed app.
@dariush7272
@dariush7272 4 месяца назад
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!
@26263kutz
@26263kutz 3 года назад
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
@thalialoiola1911 2 года назад
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
@SQLBI 2 года назад
It should be good as well, as long as it is provided by Active Directory.
@SalmanKhan-ol4sm
@SalmanKhan-ol4sm 3 года назад
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
@SQLBI 3 года назад
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.
@sergiomurru5055
@sergiomurru5055 4 года назад
Very interesting video! Thank you Marco and Paolo
@frenamakenson9844
@frenamakenson9844 6 месяцев назад
thx for sharing
@mcscunha
@mcscunha 3 года назад
EXCELENT!... I love this tutorial. It helps me too much! It was I needed. Thank you very much.
@pritichaudhari7596
@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.
@pro1427
@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!!
@MrWLKNSN
@MrWLKNSN 4 года назад
This is for push datasets only. Is there a way to combine this with a normal dataset?
@marcorusso7472
@marcorusso7472 4 года назад
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
@MrWLKNSN 4 года назад
@@marcorusso7472 reply well appreciated! Will check tom api Thx
@dhawalpmehta
@dhawalpmehta 3 года назад
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
@SQLBI 3 года назад
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
@dhawalpmehta 3 года назад
@@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. :)
@chadd_robertson
@chadd_robertson 9 месяцев назад
This is a brilliant video. Thank you.
@davepoleon
@davepoleon 4 года назад
Top class!...thank you.
Далее
Power Platform Service Account Vs. Service Principal
33:26
Securing your API secrets in Power BI
20:27
Просмотров 2 тыс.
Power BI Service Principals 101
9:23
Просмотров 30 тыс.
Power BI in Python | Authentication
30:30
Просмотров 14 тыс.
Refresh your data in Power BI WITHOUT a user???
10:39
Embedding with Power BI - What's the difference?
10:46
Просмотров 122 тыс.