Forum Discussion

mjoseph111's avatar
mjoseph111
Helper II
6 months ago
Solved

Linked Server Authentication Fails

I’m running into an issue where SQL Server linked server queries no longer authenticate in the latest version of Power BI Desktop.   My questions: Is this a known issue with the latest Power BI ...
  • mjoseph111's avatar
    mjoseph111
    6 months ago

    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.

v-hjannapu's avatar
v-hjannapu
Community Support
6 months ago

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.

v-hjannapu's avatar
v-hjannapu
Community Support
6 months ago

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.