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.

mjoseph111's avatar
mjoseph111
Helper II
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,

    Good to hear that the issue is resolved.

    If you face any other problems later, please feel free to reach out here. We will happy to help you.

    Regards,
    Community Support Team.