topic Re: Importing data from multiple excel files in Power Query

Importing data from multiple excel files

MHelmer — Fri, 25 May 2018 08:09:57 GMT

Hello,

I imported data from 2 excel files in the same folder, both identical in data format and column headers (it's the same SAP export created a few weeks apart). All columns are imported correctly except for 1: the "KEY" column I use to create unique identifiers (a part number can exist in different plants, but only on pn-plant combination exists in each file).

The query imports the key values for one of the files, but the cells are blank for the other file.

However, if I copy-paste the data in one excel file and import that one it's okay.

Anyone an idea of what might be the issue?

Many thanks

KR,

Marlies

Re: Importing data from multiple excel files

quentin_vigne — Fri, 25 May 2018 10:23:23 GMT

Hi MHelmer

instead of importing them separatly you can import from folder

https://powerbi.tips/2016/06/loading-data-from-folder/

If the files are the same, the problem will disappear

- Quentin

Re: Importing data from multiple excel files

MHelmer — Fri, 25 May 2018 10:40:14 GMT

Hi quentin_vigne

I am importing them from the same folder...

Re: Importing data from multiple excel files

Anonymous — Sun, 27 May 2018 03:04:38 GMT

MHelmer,

Is there any possibility that you share us the Excel files? I will test them in my Desktop and you can share the file through online service such as OneDrive.

Regards,
Lydia

Re: Importing data from multiple excel files

MHelmer — Wed, 06 Jun 2018 13:29:27 GMT

Hi Anonymous,

I restarted the entire thing and it's working now, thanks.

Marlies