Excel Files

[kdas]

Hello!

I have an excel file with 2or more sections of data. The new file is sent to a shared folder everyday. Each section has it's own header. The number of columns and header may or may not be same. How can I pull this information into power bi into different tables? For example section 1 data into table1 and section2 data into table2 and so on?

Thank you!

[lbendlin · Accepted solution]

You cannot pull this data into different tables in the same query.  You need to create two queries, one for the upper table and one for the lower table.