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]),
Annemieke's avatar
Annemieke
Frequent Visitor
1 year ago

Thank you, this works! ğŸ˜Š

ZhangKun's avatar
ZhangKun
Super User
1 year ago

Note: "InferSheetDimensions = true" cannot be modified, but all other parameters can be modified.
This problem is very rare. If there are still type problems, just use the above method.