Forum Discussion
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 ...
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
Hi AlB !
Here is the table returned in the first step:
The second step returns this table:
And the problem occurs if the "Table" in column Data in step 2 is empty. You can see the error I get here, when I try to view the table in column data in step 2:
Thank you for your help, really appreciate it!
