No video :(

Power BI Service Principals 101

Подписаться 448 тыс.

Просмотров 29 тыс.

50% 1

Service principals can be very useful when working with Power BI. From Power BI Embedded, to API and PowerShell. Adam breaks down how to get going with Power BI service principals.
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #ServicePrincipals #GuyInACube

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

28 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@jcramireztello 2 года назад

good video, I was looking for how to configure for weeks, I have solved my questions in 10 minutes. thank you

@Brettp7676 3 года назад

good video, was glad he didn't leave out lack of support for the Admin APIs...have been 'making it work' in terms of admin automation scripts via user account creds for quite a while

@Bharath_PBI 3 года назад

Yes we are using service principal. good to know. Thank you. 👍

@ghazanfarabidi4137 3 года назад

Thanks for confirming they don't work to retrieve activity logs. I gave up a couple months ago. I do have a python script hooked this way which sends notifications if a dataset or dataflow didn't refresh by the time it was expected to.

@JackOfTrades12 3 года назад

Nice video! Our team is using managed identities instead for added security, and I'm running my final powershell script from Azure Automaton (I use my work creds when testing). We're trying to augment refresh schedules, retries on failure, and logging refresh data using powershell since it basically simplifies interactions with MS products.

@TheSagarbhardwaj 3 года назад

HI are you able to access reports using power shell scripts in azure automation account ? If yes is there any additional activities needs to be done in automation account for power bi modules to run ?

@connorbarrett8583 3 года назад

Also ran into the limitation of not being able to call the Admin API using a service principal. Just using user credentials for now. Hopefully that comes in the future!

@ivanmarquez4987 2 года назад

Hello Connor, I've been struggling with service principals to authenticate and use the APIs. How are you consuming the APIs with user credentials? Any code reference will be greatly appreciated. Thanks!

@Rothbardo 3 года назад

No documentation in the description that was mentioned in the video

@singhrakeshr 3 года назад

Thanks. For a dataset connecting to dataflows, publishing to power bi service using service principal and power shell is straight forward but once published how to do Oauth2 authentication to power BI with service principal in datasource setting of dataset? Gateway will be switched off as dataflow is cloud datasource. Any ideas? Perhaps using update datasource api?

@AndresRodriguez13102012 3 месяца назад

Hi there! Nice video! i am trying to use a service principal in the power bi connector for power automate but looks virtually imposible. Do you know if there is a way to do this? Thanx!

@DanielWillen 2 года назад

Is there a way to quickly add the service app to all workspaces in the tenant? The API only allows access to the workspaces you are a member of, but adding the app id to each and every workspace takes time, and when people create new workspaces, they would be invisible to admins and the app. You can add users in bulk (emails) but not the app id :(

@angeljmartel Год назад

no answer yet.. I am looking for the same thing.. good luck to us!

@souravbanerjee2916 2 года назад

Hi this is amazing content. Great to find this on RU-vid. I have a question - If we want to access the Power BI rest APIs using service principles , is there a way we can do without storing username and password on the .pbix file?

@DennyEapen Год назад

Nice video. Thanks. Can we use the service principal to be used as datasource credentials to connect to azure sql database or synapse from Power BI?

@angelfish423 2 года назад

This is really great thank you so much. I am new to understanding the service principal account this is really good (only just catching up!!) - anyone know if we can now use this against the admin APIs - as I ideally want to build a report against these thanks!

@komalgupta5448 Год назад

We have done everything as it is, however when we rendered the paginated report, it ask for a separate sign-in. Since I have a Pro license, I can login and see the report, but our external user doesnt have pro license. are we missing something here? Please help.

@sahilkothekar9927 2 года назад

Hi faced an error stating - Accessing dataset requires effective identity to be provided. I have a live connection to azure analysis services

@miguelojeda2390 2 года назад

Hi, what should I use to monitor and measure my capacity performance? is there a useful tool?

@josefilomenogonzalezgutier6259 2 года назад

Hi, when I create the group and search for my registered app nothing comes up under the corresponding name, is this normal or am I doing something wrong? Thank you.

@argelpamintuango1956 Год назад

where did you created that embeddedapps in azure? I'm not referring to Embedded Demo

@pabeader1941 3 года назад

Our tenant admin is no longer with our company. How can we get admin access to our tenant?

@alexcord 2 года назад

Shoud the work to power BI Premium as well? I'm geting authorization errors.

@user-xi1by4li5k 2 года назад

Better to use postman than some particular library.

@JohnnyNguyen91 3 года назад

Is there any additional setup when working with a live connection to analysis services? Any additional permissions need to be granted from the model perspective?

@sahilkothekar9927 2 года назад

Hey have you figured it out. I was getting an error saying accessing dataset requires effective identity to be provided

@aaronwatsky7741 3 года назад

For anyone in the government tenant, you need to change your api to match.

@SivaSailamramalingam Год назад

I am trying to use the same thing. But I don't have dot net setup. I have nodejs setup. it fails in embedToken API. Could you please help on the same? Error Details: Error while retrieving report embed details Forbidden RequestId: a4ad941f-a1f9-4ada-97ec-211790866de3