Forum Discussion
Continue List.Generate() even when API request is Null to Allow for Incremental Refresh
I have created a function to query an api and am now trying to implement Incremental Refresh. I am using List.Generate() to paginate through the api. The api allows me to use a query based on the eve...
How do you deal with blank results for a given eventDate value? I have a similar script and if there are no records,
#"Expanded Column1" = Table.ExpandListColumn(#"Converted to Table", "Column1")
will cause an error as there is no Column1.