question

ButeeSaiprakashBPMAStratSLMBIPDEB-3936 avatar image
0 Votes"
ButeeSaiprakashBPMAStratSLMBIPDEB-3936 asked formaperso answered

How to use Power query when the worksheet has more than 1 table?

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

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

formaperso avatar image
0 Votes"
formaperso answered

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 ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.