Forum Discussion
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...
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
Is this question better suited for the Power Query forum? If so, am I allowed to repost over there?