Forum Discussion
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 ...
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.
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.