I have a query that results in an error - but I want to append it in other queries anyways - how..?

[Skwalla]

Hi all,

I basically want to create a query, that references other queries, and I want to make this work - even when on of the sub queries that is being referenced, results in an error. Here are the specifics:

I have a query that appends multiple other queries. My issue is, that one of the sub queries results in an error for some customers, while not for others. I need to use the exact same datamodel for all customers, hence I need to build the model in a way that it can account for one of the sub queries resulting in an error, without the main query resulting in an error.

It looks as follows:

- "Standard Definitions" and "Non-Standard Definitions" are based on manual input and will never change nor result in error.

- "gap_powerbioptionsetrefs" will work for some customers, and not for others. When it works, it will have the exact same format/content as the "Standard Definitions" and "Non-Standard Definitions" queries. When it doesn't work, the whole query will result in an error.

- "All Translations" first combines "Standard Definitions" and "Non-Standard Definitions", and in the next step it appends "gap_powerbioptionsetrefs". By removing duplicates after this step, I reach my goal: 1 table, containing all translations - from "gap_powerbioptionsetrefs" if there is access to this, and if not, from "Standard Definitions" and "Non-Standard Definitions".

Currently, my query "All Translations" looks like this:

So, any suggestions as to, how can I build a query that will work no matter if one of the queries that it appends/references/merges has resulted in an error?

NB. Since I use the query "All Translations" in other queries in the data model, it is not really an option to just keep the above-mentioned queries in seperate queries and then use relationships outside of the query editor.

Thank you in advance!

[Anonymous]

Hi @Skwalla ,

If I understand correctly, you want to combine  "Standard Definitions" and "Non-Standard Definitions" and gap_powerbioptionsetrefs as "All Translations". But it got error when merge gap_powerbioptionsetrefs and merged query("Standard Definitions" and "Non-Standard Definitions"). Could you please share the related error message and other customers info which not working? It is better if you can share your sample pbix file with us. Thank you.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.