Power Query - Expression error due to _Filterdatabase created by Excel

Question

Good day,

I have an error in power query

Today I added an automatic filter to sheet 5 (called Data Extraction) and my Query's broke. 

When trying to refresh I get this error:

"[Expression.Error] We couldn't find an Excel table named "Data extraction'!_FilterDatabase'."

My query's only need sheet 1 and 3.

My query's have no syntax errors but the problem appears already in the first step:

'=Excel.currentworkbook()'

and gives me the following:

Deleting this Error row in power query does not work and removing and clearing all the filters in sheet 5 also does not work

My question:

Can I either

1. Adjust the source and tell power query to load only sheet 1 or sheet 3 as the source, how to I do this?

or

2. Remove or solve the error and how?

Thanks in advance!

Answer 1

Hi,

Thanks for trusting us and posting in this community, we are glad to offer helps if anyone encounter common problems or issues during using Excel, but according to your description, considering that your question focuses on Power Query, which is beyond our support scope, I would like to suggest you post a new thread in Microsoft Q&A or Microsoft Excel Tech Community, these are our dedicated platforms that can cope with the related questions and issues.

We are willing to help you, but we are afraid of providing any incorrect information that may not benefit for you, we sincerely hope you can get the problems resolved with the help of experienced supports and community members. We also welcome any community members to share new ideas about your question if one has related experiences.

Your understanding will be highly appreciated.

Best Regards,

Arck