Hi All,
I would like a method to import the entities and types in my power bi dataset with tweets similar to this sentiment model in: http://nisalbi.blogspot.com/2017/10/step-by-step-twitter-sentiment-analysis.html
This is the resultset from this method but I can't be sure how to import this and put this in a list of most common Persons or organisations within Power BI (https://docs.microsoft.com/en-gb/connectors/cognitiveservicestextanalytics/#EntitiesResult)
Here is the resulset from a recent politician's tweet. How would I process this into PowerBI for an indeterminate number of Entities?
[
{
"id": "2020-05-30T10:24:57.000Z",
"entities": [
{
"name": "AOC",
"matches": [
{
"entityTypeScore": 0.8878183960914612,
"text": "AOC",
"offset": 1,
"length": 3
}
],
"type": "Organization"
},
{
"name": "Riot",
"matches": [
{
"wikipediaScore": 0.207984138670666,
"entityTypeScore": 0.8,
"text": "Rioting",
"offset": 48,
"length": 7
}
],
"wikipediaLanguage": "en",
"wikipediaId": "Riot",
"bingId": "edfc8233-01bd-45cf-0878-a66dec3ddc51",
"type": "Other"
},
{
"name": "George Floyd",
"matches": [
{
"entityTypeScore": 0.966582179069519,
"text": "George Floyd",
"offset": 165,
"length": 12
}
],
"type": "Person"
}
]
}
]
How can I go about this with a power apps flow + power bi streaming dataset?
