Writing this post to seek suggestions in regards to the below error i am facing while "Edit Query" in PBI Desktop.
DataSource.Error: An error happened while reading data from the provider: 'System.IO.FileLoadException'Details: DataSourceKind=SQL DataSourcePath=<<servername> Source=<<xyz>>
The server can be accessed through SSMS(Sql server management issue) and posses all the required privileges to perform data manipulations.
Please help in this regard. Thanks in advance!!
Go to Solution.
Thanks fo the response.
This issue was specific to a particluar server.Most likely a networking issue.
Just had a work around to connect to another instance of that server.
Thanks again 🙂
View solution in original post
Proud to be a Super User!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.