Forum

Notifications
Clear all

Power query import files from folder

2 Posts
2 Users
0 Reactions
70 Views
(@zohar)
Posts: 5
Active Member
Topic starter
 

Hello,

I have several excel files, which I have imported and merged using power query excel tool.

It worked great until I added some pivot tables and added sheets into one of my excel files.

The question is how can I direct power query to exclude/ignore specific sheet names?

Any idea?

Thanks

 
Posted : 19/02/2021 1:24 pm
(@mynda)
Posts: 4762
Member Admin
 

Hi Zohar,

You need to go back to the step in the query where the sheets and tables are listed and filter out the ones you don't want to include in your query.

Mynda

 
Posted : 19/02/2021 8:20 pm
Share: