Forum Discussion

Manichin's avatar
Manichin
Frequent Visitor
2 years ago

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.

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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