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 🙈