Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Can anyone help me with this json file scenario?
I have a folder with multiple json files having the same structure. Each json file has some columns having single value whereas some other columns have list values(list- value) pair. Want to generate a report that has data from all the files in this folder.
I started by taking a single JSON file, transformed the list columns of it into separate tables....making each of it as a separate query( I added an index column). So for a single json file, apart from the source I have multiple queries corresponding to tables. Relationships are also set between all of these queries.
How do I generate a tabular report with source columns and also include the list column names in it,.... corresponding to a master record, there are multiple list values. I am not able to get the values of the list in the report.
Can anyone suggest me how to proceed?
Also I plan to append the queries of the rest of the json files to these, is that the right approach?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |