Forum Discussion

andi2333's avatar
andi2333
Helper I
2 years ago
Solved

Need help for a simple try otherwise query

Hello, I am pretty new to powerBI and this forum and I am seeking help for a seemingly easy case.   I am trying to load data from multiple excel sheets which are all in a folder. Each sheet has mul...
Need Help
  • AndrewPF's avatar
    AndrewPF
    2 years ago

    I think you may need another "try": 

    #"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise try Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],

AndrewPF's avatar
AndrewPF
Helper V
2 years ago

I think you may need another "try": 

#"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise try Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],