_xlnm._FilterDatabase

[Anonymous]

I am receiving this error across three sheet names from an excel document in Power Query Editor. This dashboard is now not presenting the data and power query editor is unable read the sheet names? Can anyone help me with this?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Based on my web search, it seems that you might have encountered a step-level error caused by a change in the sheet name of your data source. One possible solution is to modify the Transform File function in your query with a try statement that can handle different sheet names. For example:

let Source = Excel.Workbook (Parameter1, null, true), Sheet1_Sheet = try Source { [Item=“Sheet1”,Kind=“Sheet”]} [Data] otherwise Source { [Item=“Sheet2”,Kind=“Sheet”]} [Data], #“Promoted Headers” = Table.PromoteHeaders (Sheet1_Sheet, [PromoteAllScalars=true]) in #“Promoted Headers”

You can replace Sheet1 and Sheet2 with the appropriate names for your data source. You can find the Transform File function on the left side of the Power Query Editor window. For more information on how to deal with errors in Power Query, you can check out this article: Dealing with errors - Power Query | Microsoft Learn

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.