Forum Discussion

Annemieke's avatar
Annemieke
Frequent Visitor
3 years ago
Solved

Import Excel - No data shown, only headers

Hi,   I am receiving an Excel file a couple of times a day with a status overview of processed orders. I want to combine these files in Power BI to create a summary, but I am not able to get the da...
Need Help
  • ZhangKun's avatar
    ZhangKun
    1 year ago

    If it is xlsx file, then try the following code:

    // #"Imported Excel workbook" = Excel.Workbook(#"Navigation 1", null, true),
#"Imported Excel workbook" = Excel.Workbook(#"Navigation 1", [UseHeaders = null, DelayTypes = true, InferSheetDimensions = true]),
ND_Pard's avatar
ND_Pard
Helper II
3 years ago

At first glance, the result shown did NOT promote the headers; i.e., the header is shown as a record instead of as a header.

Not sure if my comment is helpful, but I hope it is.

Good Luck 🙂

Annemieke's avatar
Annemieke
Frequent Visitor
3 years ago

True, in the print screen the headers were not yet promoted ğŸ™‚ But the issue is that there is nothing below that row, although there is data in the excel file. Promoting the headers only leads to having no rows at all anymore.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Annemieke ,

     

    First check that the output of these previous steps is as expected.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

    • Annemieke's avatar
      Annemieke
      Frequent Visitor
      3 years ago

      Hi Gao,

      Thanks for your response! Yes, the output of the previous steps is as expected. I see all emails, am able to expand the attachment columns and can open the needed binary of an excel file or combine the excel files that are in the attachments.

       

      I don't get any errors, but for some reason only the first row is imported for these files, which only contains the headers.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Annemieke ,

         

        I checked the code and there seems to be nothing wrong with it. Please find the file according to the previous filter and check if it is empty.

         

        Best Regards,
        Gao
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly --  How to provide sample data in the Power BI Forum