cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

twitter entity analysis

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",
        "wikipediaUrl""https://en.wikipedia.org/wiki/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?

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: twitter entity analysis

Hi , @treeofwisdom100 

It seems that only  one entity in the streaming dataset is supported by design.

It is recommended to create a streaming data set for each entity.

 

BTY,you  can also   use web data source to call Twitter API and do the data cleaning in Query Editor .

Please refer to these related posts and video.

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

https://www.youtube.com/watch?v=i88CBli0uQc

 

Best Regards,
Community Support Team _ Eason

Highlighted
Community Support
Community Support

Re: twitter entity analysis

Hi, @treeofwisdom100 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors