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.
