In my worksheet which I want to load in power query. There are more than 1 tables. And trying to load them I get the error that the data is too big. Its not more than 500 rows and only problem is that multiple Tables exist in this worksheet
In my worksheet which I want to load in power query. There are more than 1 tables. And trying to load them I get the error that the data is too big. Its not more than 500 rows and only problem is that multiple Tables exist in this worksheet
Hi,
Did you try to use the Excel button Table ?
More infos on that : https://www.cedarville.edu/insights/blog/excel-convert-data-into-an-excel-table.aspx
If you do so, all your tables will be recognised by power Query and you can choose the one you need with the navigator windows.
Does that help ?
3 people are following this question.