Power Query - "If query fails, skip step and carry on". How should I code this?

[dinosainsburys]

I have a PBI tool which ingests Excel worksheets where the number of them can change. I have a PBI tool currently with 8 seperate versions, each pertaining to the number of worksheets depending on the file ingested. How can I code something, so I can bring it together into one PBI file? Essentially, if I use an 8 worksheet PBI file to ingest a 3 Excel worksheet file, it will fail. Is there a way for PBI to ignore errors and continue the import and subsequently the appending of them?

[Ritaf1983 · Accepted solution]

Hi @dinosainsburys 
In the current context, the answer is no.
But you can import Excel files with dynamic sheets.
Please refer to the linked tutorial:

https://www.youtube.com/watch?v=JZSdAvGAq_E

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[kleigh]

You could use a try... otherwise block. Error handling - Power Query | Microsoft Learn

It may be possible to re-structure the import so it iterates over the present sheets, rather than trying to access a fixed amount.