Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query - Append if no error

Hello,   I have 2 queries, for Primary Model & Comparison Model which i need to Append.   The Comparison Model will not always be there, thus its query will have an error when it is not defined. ...
Data Protection
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello Anonymous 

     

    in addition to the answer of edhans you can try if this solution would work out for you. This only worsk if your ComparisonModel gives an error, not only a cell value with an error

    Result = try Table.Combine({PrimaryModel, ComparisonModel}) otherwise PrimaryModel


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

edhans's avatar
edhans
Community Champion
5 years ago

The Comparison query always has to be there. You cannot have queries popping into existence and then vanishing on each refresh. The contents of the Comparison query may change. It may return errors, it may return 0 rows, or valid data.

 

So please define what you mean by "not defined." Read this info to help us with good info. How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.