Forum Discussion

sabeer6870's avatar
sabeer6870
Microsoft Employee
6 years ago

Can I query a Datasource based on an existing Dataset column?

Hi,   I queried a data source and got the dataset, in that datasource there is column lets say, "region". Region           |  Column2 | US East 2       |         x       | Asia West 1   |       ...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

But the Power Query Editor only loads the first 1000 rows into the preview.

How can it be too large for that?

sabeer6870's avatar
sabeer6870
Microsoft Employee
6 years ago

Even then it wouldn't be efficient, i have millions of rows in the table and out of those I just want 2-3k records.

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi sabeer6870,

     

    I am disappointed that you do not believe in Query Folding and have not even tried it.