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

Butee,Saiprakash (BP MA Strat + SLM) BIP-DE-B 1 Reputation point
2021-03-26T08:06:14.687+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,970 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olivier Aillery 1 Reputation point
    2021-04-02T09:52:19.61+00:00

    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 ?

    0 comments