Forum Discussion
Separate two tables in the same Excel sheet
Hi, I have following data (screenshot added below) and I would like to separate the two tables in Power BI, so I can use them separately. https://prnt.sc/qng0ma The tables are always deli...
Hi Anonymous
Please see the attached file with a solution
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Anonymous
The easiest way is to set both sets as seperate tables in Excel (select the cells for one table and press ctr + t; repeat for second table) and import them in Power Query as separate tables. This way they will remain separate on refresh.