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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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