Forum Discussion

fabo's avatar
fabo
Advocate III
8 years ago
Solved

Error while connecting to SQL database after PBI last update

Hi everybody.   Before last Power BI (PBI) update I was able to correctly connect to a SQL database from my organization using SQL Server connector in PBI. Today I updated PBI to the latest version...
Need Help
  • fabo's avatar
    fabo
    8 years ago

    Update:

     

    After making a lot of attempts and failures I finally got it solved and I found what was the problem. 

     

    Before the lastest update (January 2018) there were 3 login methods when connecting to SQL database: 

     

    1. Windows
    2. Basic
    3. Organizational Account

    Back then, I used to login using Organizational Account option.


     

     

    Now, with the latest update the third option changed to: "Microsoft Account".  So when I tried to login using this method, the validation proccess failed.  Now, if I use the first option... voilà! I am able to connect to my organizational SQL server again! :smileyvery-happy:

     

    It would be nice if someone could add some information about this change.  I searched the web and I didn't find anything.

     

    Greetings!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How were you able to get that menu screen to select the options for signing in again? I'm stuck in a loop of it just giving me the error message and I can either edit and/or retry and it will just continue to fail and I do not get the option to change my login method.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Go to Power Query Editor ->Data Source Settings(on the Ribbon) -> Edit preferences->Edit Credentials->Choose Windows credentials to access the database