Thank you, +1 in my learning. I used to do the same thing but I used to load data in PBI do the parsing and then download the data, here I learned how I can directly do the same thing without having PBI installed in my machine. Thanks a lot Paula for making this video tutorial
Very interesting. Thanks. Pardon me for pointing this out, but you are using the work "phrase" when you should be saying "parse" which means to break apart. It confused me at first until I realized when I zoomed in what menu option you were clicking.
This was very helpful! What I did was to duplicate a column and then use different method to get the data in the metadata column. Thinking back, I think your method is better with this example data.
Thanks for sharing. It solved a thorny problem :). The blog link you shared above is blocked by Chrome with the message "this page is trying to load scripts from unauthenticated sources". You might want to look into that.
Paula when I dont know the data in json file, How would I know column headings and data type in each cell while transforming in power query ? Also when I converted json file to excel multiple work sheets are there. HOw can I get to know in power query that data exists in multiple work sheets.
Thank you for this tutorial. My json is array of pairs, field_name and field_value.How to parse that field_names become columns and field_value is the value in those columns? Thank you!
This was very helpful. My boss was impressed with me.
You can please your boss then :D
Thank you, +1 in my learning. I used to do the same thing but I used to load data in PBI do the parsing and then download the data, here I learned how I can directly do the same thing without having PBI installed in my machine. Thanks a lot Paula for making this video tutorial
Very interesting. Thanks. Pardon me for pointing this out, but you are using the work "phrase" when you should be saying "parse" which means to break apart. It confused me at first until I realized when I zoomed in what menu option you were clicking.
Just what I needed. Many thanks
This was very helpful! What I did was to duplicate a column and then use different method to get the data in the metadata column. Thinking back, I think your method is better with this example data.
This was super helpful. Thank you so much for doing this!
Very helpful! Thank you.
Thank you Very much. This helped me a lot
Thank you, it's working for my case.
Thank you, really helpful video!
Thank you so much!! Your video was a great help to me :D
How would you then reverse this back into JSON and re-import back into the originating system as a way to update the data?
Thank you, this is very helpful!!!
Thanks for sharing. It solved a thorny problem :).
The blog link you shared above is blocked by Chrome with the message "this page is trying to load scripts from unauthenticated sources". You might want to look into that.
thank you
Paula when I dont know the data in json file, How would I know column headings and data type in each cell while transforming in power query ? Also when I converted json file to excel multiple work sheets are there. HOw can I get to know in power query that data exists in multiple work sheets.
very useful! thanks
Glad it was helpful!
Thank you for this tutorial. My json is array of pairs, field_name and field_value.How to parse that field_names become columns and field_value is the value in those columns? Thank you!
thank you so much
Link doesn't work and file doesn't exist in drop box. Would be very grateful to have them updated
For mac?
Great. Thanks. Btw nice Irish accent. :-)
Thanks! 😃
4:06 lolwat? It's "parse" not "phrase" 🤣