Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SP
Frequent Visitor

datasource error

Hi All,

 

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!!

 

Cheers

 

 

1 ACCEPTED SOLUTION
SP
Frequent Visitor

Hi,

 

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 🙂

 

Cheers

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi there, do you have any other issues with other data that you load?

The reason for the question is that it appears that possibly it could be with Power BI Desktop, or if there potentially an issue with the hard disk drive on the PC you are working on.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

SP
Frequent Visitor

Hi,

 

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 🙂

 

Cheers

Glad you got it now working.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.