Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All my Power BI models are failing to connect to my MS SQL Server after a recent Power BI update. I am getting the following error message with Windows authentication:
If I try and use the Microsoft Account authentication, i get the following error message:
However, i can manage to connect to the Server via SQL Management Studio. Please assist.
Best regards.
Chris
Solved! Go to Solution.
Hello, managed to troubleshoot the problem. It was actually a conflict with a newly installed SQL Server 2017 Developer Edition on top of SQL Server 2014. When i uninstalled SQL Server 2017 Developer Edition, everything was now working.
Regards,
Chris
@Chitemerere was it working before? Do you use mixed authentication on sql server? Can you try database credentials?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello, managed to troubleshoot the problem. It was actually a conflict with a newly installed SQL Server 2017 Developer Edition on top of SQL Server 2014. When i uninstalled SQL Server 2017 Developer Edition, everything was now working.
Regards,
Chris
Many thanks for your prompt resonse, most appreciated. Yes i was able to connect to the Server before the update. Yes i have mixed mode authentication. If i try using the database option i get the following error message:
Best regards,
Chris
@Chitemerere can you try to use 127.0.0.1 instead of localhost.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you very much for your input, most appreciated.
Regards,
Chris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |