Forum Discussion
Helper IIIpower query connecting to sql server(user id and password) is not working on another user computer
Hi Team,
i need your help.
i have created one model which is using power query, in this model i'm connecting to sql server using user id and password authentication.It works fine for me but gives authentication error when used by another user.How can we fix that ?
Hi shashank,
Regarding to the Power Query issues, I would recommend you post the question in the Power Query forum to get dedicated support.
In addition, you can consider to use Power BI Desktop to connect to SQL Server in import mode, then create model and reports. This way, when you send the Power B Desktop to other users, they don’t need to enter credentials.
Thanks,
Lydia Zhang
8 Replies
- BhaveshPatel
Super User
Are you using the same file to connect to SQL Server using the different user names? If yes, You should try and create parameters for connecting to separate instance of SQL Server
shashankHi Bhavesh,
type of security in sql server is user name and password, i supplied the same intially when i was connecting to sql server.
another user is supposed to use same credential but i'm assuming that credentials are saved somewhere in power query and another user will not provide any credential while reunning that model, as another user is business user who has no idea regarding those credentials.please correct me if my understanding is wrong..
- BhaveshPatel
PowerQuery saves all authentication data to an encrypted file on your local hard drive instead of the PowerBI File.
