Forum Discussion
Not all columns expanding because first 1000 fields are null
Wondering if there is a way to expand ALL columns from a Json.Document(Web.Contents...) => Table.FromList source when some columns don't have data in the first 1,000 rows. I'm aware of methods s...
I put a parmatised query in the API call to make sure I get a record that isn't null, complete the transformation and then remove the paramatised query from the first step.