Forum Discussion

Mike282's avatar
Mike282
Helper III
6 years ago
Solved

How do I change the credentials for a Dataflow pulling from a SQL server behind a gateway

Hi all,   So I've got a issue. I have a dataflow which I created that pulls data from two databases in a SQL server behind a gateway. When I initially created the dataflow I didn't use one of the s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mike282,

If you are work with a normal dataset, you can turn on the SSO option to use end-users' credentials to connect to the dataset. 

Azure SQL Database with DirectQuery#single-sign-on 

I check on dataflow and it seems not available on dataflow entity, perhaps you can turn the SSO option on your gateway datasource to access with users' credentials.

Configure Kerberos-based SSO from Power BI service to on-premises data sources 

Regards,

Xiaoxin Sheng