Excel is a powerful tool that allows you to connect to JSON data and read it. However sometimes this data might require a little manipulation to be fully understood and analysed in Excel. You can download the data to practice along with this video from the blog.
The Excel Club Blog has been powered with #STEEM. That means we are a tokenized website and you can earn while you learn Excel, PowerBI and DAX. All you have to do is engage with the post on The Excel Club Blog, so if you have any questions or comments I would encourage you to post them on the blog and not here on the video
Sign up to our newsletter
Watch more Power BI videos
Watch more Excel Videos
#share2steem #excel #json #steem #exceltips #tutorial
#powerquery
Nguồn: https://2forum.biz/
Xem thêm bài viết khác: https://2forum.biz/category/cong-nghe/
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.
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.