SQL has a bit of a learning curve, but it's well worth the effort for the more complex queries. The MS SQL Server can also query into the JSON data used often by Steem.
You are viewing a single comment's thread from:
SQL has a bit of a learning curve, but it's well worth the effort for the more complex queries. The MS SQL Server can also query into the JSON data used often by Steem.
oh I am glad I saw this comment @eturnerx, I just downloaded PowerBI last night and was playing around with it and couldn't figure out why I couldn't see the JSON data. That is actually a pretty major limitation if PowerBI can't query into the JSON data - that is where the other 4 tags of a post are held! So PowerBI can only search by first tag if it can't see into the JSON metadata. Almost all of my queries use the JSON data in fact!
@carlgnash you can see into the json columns, and you can also phrase them into normals columns too with power bi
oh okay I obviously need to read some of your power BI tutorials :) When I was first looking into the Comments table using Power BI, in the data preview I was able to see results for all the other columns, but not the JSON metadata. Good to know you can access those with PowerBI, it would have been a deal breaker for me otherwise. Cheers - Carl