Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
11 | |
7 | |
6 | |
6 |