Log In
Register
Home
Active Member
March 22, 2022
Offline
Dear,
When I refresh my query 'GitClean,' the error message pops up showing that 'expression.error we couldn't find an excel table named ' bug_trend_data_filterdatabase'
It's weird that every step of my GitClean doesn't include reading the worksheet 'bug_trend_data' so I can't find anyplace to delete any step relating to 'bug_trend_data_filterdatabase.' I've tried search in data source setting, but I couldn't find any....
Link of the file:
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Yachu,
Look at the step where you have the list of sheets and tables. If there is a filter applied in one of the source file sheets, there will be an entry named FilterDatabase, you have to filter out these entries. Filter the Kind column for Sheet only, or tables.
Active Member
March 22, 2022
Offline
Dear Catalin,
Thank you for the reply!
I've tried as you said but still got the same message. (I've posted in images)
So I am not sure what you mean of ''a filter applied in one of the source file sheets'' and "filter out these entries."
Is it possible that you can provide any further step-by-step guidance or pictures?
Thank you so much!!!
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Look at your query steps, from the beginning of the query.
Filter the Name column to remove FilterDatabase entries from that list.
In the second step, Expanded Content, you are combining all those tables, many of the entries from that list are defined names (Andrew, Bernie, Bryant), referring to a specific range of cells.
Are you sure you need those? Before expanding content, make sure you have in the list ONLY the relevant data sources. Expand Content will not magically clean what should not be there, only you decide what is relevant.
Answers Post
Active Member
March 22, 2022
Offline
Dear Catalin,
Wow, problem solved!
Thank you so much for the guidance.
I don't know before expanding content will automatically add source to existing query. Thanks for the notice!
I'll definitely take a look into it.
Grateful~
1 Guest(s)
