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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Manichin
Frequent Visitor

Sharepoint file load error

I am getting error in power bi report which uses excel from sharepoint loacation. the report was working fine and suddenly started showing this error.

Manichin_0-1713192293241.png

But if i open the spreadsheet from the sharepoint and close it the data loads properly in power bi. Again to test if i restore the previous version getting error again. Note that i am not doing any change when i open the file. Simply if i open and close the spreadhseet it works fine.

Suggest me some solution to get rid of this error.

 

Thanks

1 REPLY 1
Anonymous
Not applicable

Hi @Manichin 

 

May I know what did you restore as you said "Again to test if i restore the previous version getting error again."? Restore the previous version of what? 

 

The "Transform File" query is a function. If you are using the SharePoint folder connector and combine files, the "Transform File" function is binded to a query called "Transform Sample File". Does the "Transform Sample File" query work correctly? Did you edit the code of the "Transform File" function directly? 

 

Best Regards,
Jing

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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