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

Hi, I sometimes get this error when I copy a file into a OneDrive folder. What usually works for me is going into the file and editing something (row width, etc), saving and closing it. Then Power Query retrieves the data as expected. 

Annemieke's avatar
Annemieke
Frequent Visitor
1 year ago

Thanks for your reply! Unfortunately, the files are in emails and not in a folder and I receive multiple of those emails a day for 2 years already. I connect with the Microsoft Exchange connector, with the goal to combine all the attachments. So unfortunately changing a small thing in a file is not an option 🙈