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!
You are viewing a single comment's thread from:
@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