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 kind of got it to work yesterday. I think it was an issue with the system we are using to connect to data in NetSuite. The rest api we are trying out doesnt return properties for a json object if they are null or 0. So there are instances where we get 1,000 json objects with empty (not included) properties so PBI never sees them.
PBILover
Helper V
Helper VAnonymous
Which work around did you implemented for this?