Load multiple files with different numbers of columns as a set of tables?

[StephenF]

I have 19 bar delimited files, each with a different number of columns.

Eg:

Table called Prod

Table called Emp

Table called Sales

Do I have to import them one at a time or can I batch import them?

[AlB]

Hi @StephenF 

You can import everything in a folder at once and then keep what you are interested in. Check out this for more info. It's described for Excel but the query editor is he same in Power BI.

[StephenF]

That seems to be related to combining files. Im not going to be combining any files

[StephenF]

Anyone else have any thoughts?

The "combine" step is irrelevent for where you are importing files with each one having a different numbers of columns.

[StephenF]

Support ticket time! 😞