Forum Discussion
Help with expanding json list columns
Hi all,
Thanks for your effort and replies. I found a solution to my issue from here :
https://community.powerbi.com/t5/Power-Query/Multi-Dimensional-Json-file-to-Table/td-p/113667
In the end I combined the extracted columns into one.
Hi Jimmy801
If I have understood your solution correctly, I mean that it would take forever to modify it, since the dataset contains tens of rows.
If you have an email where I can send the original dataset and pbi query, I could do it, so we could get common understanding of the issue.
Br, Jere
Hello jereaallikko
in my example I created manually a dataset to show you a solution with DAX (measures etc.). When you need to load aaaa llloooot more data, then connect power query with your dataset, and apply afterwards my solution in DAX. ----->>>> wrong threat...
so... this now is valid for your request. The code I supplied basically transform you "list"-column to extract data from a record. you just have to apply the main step in my query to your code
Hope I was now clear enough 🙂
BR
Jimmy