Forum Discussion
Lorenz33
3 years agoHelper IV
Data Gateway - Pass user credentials to data source
How can we pass users credentials through a data gateway to the data source? I understand that this can only be done with Direct Query. To try this I created a simple Power BI report that connect...
- 3 years ago
Hi Lorenz33
You have to make sure that your DirectQuery database supports SSO.
Here are the supported list: Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn
And if required here is how to configure Kerberos: Configure Kerberos-based SSO from Power BI service to on-premises data sources - Power BI | Microsoft Learn
GilbertQ
3 years agoSuper User
Hi Lorenz33
You have to make sure that your DirectQuery database supports SSO.
Here are the supported list: Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn
And if required here is how to configure Kerberos: Configure Kerberos-based SSO from Power BI service to on-premises data sources - Power BI | Microsoft Learn