Help PowerBI : dataflow , how to connect with organization credentials (windows)

[Anonymous]

Hi guys ,

i am new to Dataflow powerbi , so i am trying to use it but when i am trying to connect to database in sql server , it is always failing ,

can you show me how to connect , i am windows credentials and it an organizational account . it said that the connection has not been shared. 

Thank you in advance

[Anonymous]

Hi @Anonymous ,

Can you try with SQL server authentication?
Hope it should work.

Regards,
Amit

[Anonymous]

there is only 2 options (basic and windows )

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please, add the datasource in On-prem gateway.
Click on Manage gateway and add the Datasource.

Regards,
Amit

[Anonymous]

i am not the admin , so i need my boss to make the change 😞 who is in business trip .

Thank you so much , i will reply again when i will try it and  works .