Forum Discussion

RokuCap's avatar
RokuCap
Helper I
2 years ago
Solved

How to Dynamically Load Only the Non-Empty Tables Into the Data Model?

I have a few Excel workbooks I want to load data from every month. Each workbook will contain over 20 worksheets, each worksheet with one table. The worksheets should be loaded in their own query and...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI RokuCap,

    In my opinion, I think these operations should suitable to processed in Power query.

    If these files are stored in the folder, you can use folder connector to get data from that. Then you can add filters on different fields(they mean the file properties) to the filters connector result to filter not match records, and load data form remained files.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI RokuCap,

In my opinion, I think these operations should suitable to processed in Power query.

If these files are stored in the folder, you can use folder connector to get data from that. Then you can add filters on different fields(they mean the file properties) to the filters connector result to filter not match records, and load data form remained files.

Regards,

Xiaoxin Sheng

  • RokuCap's avatar
    RokuCap
    Helper I
    2 years ago

    Thanks Xiaoxin. I'll give the folder connector a shot. I'm still learning Power Query so I might repost this over there. But you've given me a starting point!