Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

.xlsx file not reading correctly until resaved

Hello, I am having an issue with Power BI reading data from a .xlsx file downloaded from the Internet. The web application that generates this file is likely somewhat dated, but the file exports just...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    1. It's better modifying the Excel sheet before import data from excel file, that will be a great help for you transform data in edit queries.

    https://radacad.com/power-bi-get-data-from-excel-everything-you-need-to-know

    2. I couldn't duplicate the issue and I haven't had this kind of issue for now.

     

    I think there should be something wrong in these excel file, it's better check the excel files.

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

It is 2022 and I am having this problem as well with Excel and Power Bi only reading 1 line of data.  If I resave the Excel file it works great.  This is the first time I have run into this issue.  The Excel file is being generated by software called "Orchestrator" which is an automation tool.  It produces a log of activities I want to be able to build a PBI dashboard.  But when I read this file, I only get one line unless I resave it. 

 

It is easily reproducable, and I am happy to send Microsoft a copy of the Excel file for them to look at, to determine what the issue is.  I'm certain that Orchestrator is not producing a "pure" Excel file, but it looks fine inside Excel when I bring it up.