Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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.
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
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.