Forum Discussion
Linked Server Authentication Fails
Thank you everyone for your help. I tried all the above solutions, but the problem persisted.
To resolve the issue, I moved all direct SQL connections out of Power BI Desktop and rebuilt them in Power BI Dataflows. so dashboards no longer depend on Power BI Desktop for data access. I then updated each dashboard to use the Dataflow instead of connecting directly to SQL.
Hi mjoseph111
Some users recently mentioned that they experienced an authentication issue with SQL Server, which turned out to be caused by a DNS resolution problem.
Instead of using the server name, they used the server’s IP address, and that resolved the issue. So, if you're facing a similar problem, give that solution a try.
Yea, im experiancing the same issue. sure , i will give it a try and let you know. Thank you so much!
Hi mjoseph111,
Thanks for the update.
Yes, this issue is being seen after recent Power BI Desktop updates, mainly due to changes in connection security. Please try the suggested steps shared above and check if the connection works.Once you test it, let us know the result. Based on that, we can guide you on the next steps.
Regards,
Community Support Team.Hi mjoseph111,
Have you tried the above steps shared earlier? If you have already checked and are still facing any issues, please let us know here and we will help you further.
Regards,
Community Support Team.
