Forum Discussion
JSON file drill downs
Hi Everyone, I have a question about importing a JSON file so I can access the data to report. I have the following documentation below on how to do this which was helpful, unfortunately on the...
There are several things you can try. It all depends on your particular JSON structure (a sample would be usefull to back up the answer with a meaningfull query)
1. If the list have the same structure you can carry on with Expanding the column that contains the list.
2. You can look at using Table.ExpandListColumn in your query
3. A list can be displayed in a table field by feeding Text.Combine function to it
4. Come up with a custom JSON expansion routine
6. Transform the lists back to JSON with Json.FromValue