Forum Discussion

ericjo's avatar
ericjo
Helper III
10 months ago
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...
Data Protection
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    10 months ago

    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.

MFelix's avatar
MFelix
Super User
10 months ago

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.