Forum Discussion

New Member

6 years ago

undefined

I have a excel worksheet with several excel tables and new tables will be added from time to time. Is it possible to configure Power BI query to automatically detect and connect to new tables as data...

edhans

Community Champion

6 years ago

How would you get those new tables to automatically expand to new queries though Jimmy801 - I would assume the tables would not be the same format, otherwise, they would just be additional rows in existing tables.

Jimmy801

Community Champion

6 years ago

Hello edhans

for sure they have to have the same format, or at least following the same logic to extract the data. I had one time a case were they maintained assetts in one big excel-file, and whenever a assett was created from a template and by adding a new sheet, this new data needed to be integrated in a power-pivot database.

Jimmy