Forum Discussion
Solved
Split/extract multiple tables from a spreadsheet
I have a spreadsheet that contains scores of tables of survey data analysis. I'd like to find a way to split them out into multiple tables in my data model. I've decribed the format below and added a...
Did you get the "suggested tables" feature on the Navigator screen (bottom left) when you connect to the Excel spreadsheet?
How did I miss that? Yep, that works. Thank you for pointing that out.
The automated code generated is quite impressive.
Also, there's another technique where you go into Excel and define a range on each table and powerbi can recognise that.
Good luck