Forum Discussion

shashank's avatar
shashank
Icon for Helper III rankHelper III
9 years ago
Solved

power 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 g...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
shashank
Icon for Helper III rankHelper III
9 years ago

Hi Lydia,

 

Thanks a lot for your inputs.