Forum Discussion
Solved
Sharepoint With Excel
I'm using an Excel file uploaded to a SharePoint folder. Since the name of the Excel file can change, I'm connecting the folder containing only the Excel file to Power BI. The Excel file was downloa...
Hi ericjo ,
Based on the message it seems like it can be an error of the dowload since it refers that the file cannot be understood, if you open it and save it and it's readable by Power BI it seems that the download that is being made has some additional metadata that is not recognized has a XLSX.
For test did you tried saving the file (without opening it) to a local folder and check if Power BI desktop returns the same error?
One option can be to download in CSV format insted of Excel, if possible of course.
