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 🙂