Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

hugoberry's avatar
hugoberry
Icon for Responsive Resident rankResponsive Resident
9 years ago

Hi Anonymous

I'm trying to come up with an approach to tablify JSON structures.

Based on some other use cases on this forum I've devised an approach which seems to work.

Can you please have alook if you can run this function against your dataset and check is the results are in a desirable state?

https://gist.github.com/Hugoberry/4ad49f4301edf47fffe2ef06aed61513

 

Thanks