excel - Power Query Source Item Not Case Sensitive

Question

Is it possible to have a Power Query source statement be case in-sentitive?

For example, I have 10 excel files in a folder that I need to import into my data model; with the desired data in sheets named either Detail or DETAIL.

I'm using the following statement to reference the sheets, but need to modify it so the query with work for both names:

= Source{[Item="DETAIL",Kind="Sheet"]}[Data]

Is it possible to do this?

question from:https://stackoverflow.com/questions/65832994/power-query-source-item-not-case-sensitive

Answer 1

The usual format is = try xxx otherwise yyy so this should work for you

  = try Source{[Item="DETAIL",Kind="Sheet"]}[Data] otherwise Source{[Item="Detail",Kind="Sheet"]}[Data]