Forum Discussion
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...
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:
- Windows
- Basic
- 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!
It also worked for me. Thanks for sharing!