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!
1 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.
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.
