Forum Discussion

magnus_b's avatar
magnus_b
Advocate II
5 years ago
Solved

Error handling when table is empty

Hi!   I am using direct query against an API, that will return a table with a row for each visitor today. At the beginning of the day, there are no rows in this table, so the query will produce an ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Try this:

     

    = Table.AddColumn(PriorStepOrTableName, "TableToExpand", each if Table.IsEmpty(_[Data]) then Table.FromColumns({{null}, {null}, {null}, {null}}, {"Column1", "Column2", "Column3", "Column4"}) else [Data])

     

    Now if the table is empty, you'll get a 4 column, 1 row table of null values.  Make as many nulls and column names as you need.  You should replace my "Column1" names with the actual column names.

     

    --Nate

AlB's avatar
AlB
Community Champion
5 years ago

Hi magnus_b 

Can you provide the table that you get in the first step, Source?  The M code provided does not work on my side  (I guess I need to install the connector or similar)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers