No video :(

Using Single Sign-on with the Power BI Gateway

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

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

50% 1

Let's dig into the Power BI gateway and Single Sign-On (SSO) using Kerberos! This can be used for both DirectQuery and refreshing a Power BI dataset.
Documentation: docs.microsoft...
📢 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 #GuyInACube

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

15 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

This is one of those videos that I'll need to watch AT LEAST 20 more times! LOL!!! Great stuff!

@aamoody81 4 года назад

This is a great video! We were able to implement our SSO in minutes with this video. Thanks a ton for putting this out there. Now if you have one for SAML and HANA that would be great!

@GuyInACube 4 года назад

Love it! See, Kerberos just works! 👊 I've done the SAML work with SAP HANA, that would be a much longer video. Also I don't have a personal instance to do a demo on :|

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

Any chance for the video on SAML and SAP Hana with Power BI report server?

@laancaro 4 года назад

That would be awesome but if you show us how to do it in SAP BW or SAP HANA. It's a nightmare trying to do it.

@chandinipatnaik3443 4 года назад

Same here too.. we get many SNC library errors.. for SAP BW ,.. also doesn't work for SAP HANA ... Any help here would br appreciated :)

@gsanchez7124 Год назад

same here, SSO it just does not work against SAP BW and the documentation is very unclear

@samaguire1 4 года назад

Great video! And thanks for keeping up the videos with everything going on with COVID! It really is little slice of normality for me. 👍

@spen2431 4 года назад

Hi Adam. Love your videos as always. Is there any chance you can cover MFA/2FA connections? ie Automatically refreshing a dataset that needs a password and the authenticator app..?!?

@shoebsd31 Год назад

Thanks for the great explanation!

@aamoody81 4 года назад

Great video. More of this type of stuff would be great.

@karthikgowrishankar1810 Год назад

Is there a video or document for SSO between Power BI Service to SAP HANA

@muhammadbilalattiquesiddiq4833 Год назад

Hi I check you video it is good, please create a video for sso between SAP BW and Power BI. Normally SAP Systems are not in the domain , they are on unix machine and not part of windows domain. We have successfully configure sso on SAP System and its working fine but we are struggling with on premise data source

@ajitkumar4684 4 года назад

Great info. Thanks Adam.I am using DirectQuery to Azure SQL DW but don't see the OAuth2 in the Authentication methods while trying to configure the DirectQuery Data Source. The only options I see there are Basic and Microsoft Account. Is there any setting on the Power BI tenant in order to implement SSO for DirectQuery.

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

Thanks for the video. I have done all the steps outlined here, but still not able to connect using SSO. Have a ticket opened with Microsoft Support for over 2 months now, and they can't resolve it. Error is "DM_GWPipeline_Gateway_InvalidConnectionCredentials". Would you have any ideas?

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

Hi Adam great tutorial! One question.. We didn't have to type any user name or password, that's understandable. But how is it fetching the credentials or what's going on internally to make it work?

@starmartin098 4 года назад

Hi Adam, does SSO via kerberos for import queries work for RLS, that is set in our datawarehouse (AD grops)? Thank you very much! Thank you for all your videos, simply awesome! 🤩

@robertdurrant5938 4 года назад

Excellent video. I am assuming you can do the same for SAP HANA?

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

Great video. Question: Around minute 6:00 you mention that the data sources have to be unique. I take this to mean that if you have 3 different SQL servers in the same domain (Prod, Stage, Test) that you should use different domain-based SQL services accounts. Is that accurate? I have this very situation that I am trying to setup now. Or can you get past this by using the single Prod domain-based SQL service account and 2 computer-based service accounts (NT Service)? I am still trying to wrap my head around all of this.

@sakshirawat1328 4 года назад

Hey Adam!! Hope you are doing wonderful. Is there a way for date slicer to have today’s date set as default visually?

@Jai_Radhe_Radhe 6 месяцев назад

Hi @sakshi Yes we can do it. Created calculate column on top of date column If ( date [date] = Today(), "Today", date [date]) And drag this column in slicer and select today save it and publish report Whenever user open it always selcts today by default

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

Also would be great if you show us how to do it with Oracle... It's a nightmare too

@92huylang 3 года назад

I love your content. I am designing a direct query report with a connection to Ms Azure. I struggle to change the timezone as the db stores time in GMT time zone. I understand that DirectQuery connection limits data modelling functionalities which includes the time intelligence. Do you know if there would be another way to work around this issue?

@apocalipto91 4 года назад

Thank you!!!

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

Awesome

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

I am getting an error. "We reached the data gateway, but the gateway can't access the on-premises data source." Anyone get anything similar. Kinda desperate.

@elrevesyelderecho 4 года назад

#1st Hey Adam! Thanks for this video. Helping me on my preparation. The last roundup I posted this question: "Related to Coronavirus, any chance that Microsoft postpone the June deadline for Exams/Certifications - (PBI Exam 70-778) ?" Thanks!

@alt-enter237 4 года назад

@Carlos Castro--Not sure you know this but 778 is being retired and replaced with DA100, so you probably want to take that exam instead.

@KarthikDeena 4 года назад

SSO available for SSAS ?

@GuyInACube 4 года назад

Yes for live connections

@KarthikDeena 4 года назад

Thanks for the reply, can you share a document or video which explains SSO for SSAS

@jackhillyer3397 Год назад

I believe that doing this could be a huge security risk. I think I can replicate the issue if you are interested but unless I did something wrong, you could be exposing secure data to people that don't have access to it. I discovered this trying to do this but with a data flow instead. Adam Please contact me if you have any interest in what I found.