Forum Discussion
Helper IIIpower query connecting to sql server(user id and password) is not working on another user computer
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
Helper IIIHi Lydia,
Thanks for your inputs.
Scenaraio here is little bit different.
I'm not using power BI desktop.what i'm doing is.
1-Creating a model only in Excel.
2-Connecting sql server through power query add-in in 2013 version.
3-importing data , doing some clean up then calculation.
4-Throwing that data on one excel sheet and use that in other charts and pivots.
I want to share that excel model to other users but want they should not be prompt for any password, any suggetions ?
Regards
Shashank
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
- shashank
Hi Lydia,
Thanks a lot for your inputs.