The Power BI team posted a great article about streaming tweets and sentiment data into Power BI. Unfortunately, the article does not get into the steps necessary to procure and set up Cognitive Services from Microsoft so I figured I would cover these details in this article. If you already have an Azure account, then it should not take more than a few minutes. If you don’t, you may want to go and set up an Azure subscription first (Microsoft will ask you for your credit card, however, as long as you use the F0 pricing tier for Cognitive Services, you should not incur any charges).
-
Go to this link (https://www.microsoft.com/cognitive-services/en-us/apis ) and then click on APIs -> Text Analytics
- You then need to click on Get started for free and follow the prompts. One of them will be to enter you Microsoft email address (you must have a Microsoft accounts of sorts to get past this step)
-
When the new page loads, click on
to verify your email address. You will get an email from Microsoft with a link that you will need to click on to verify -
Clicking on the link will take you to a page that will tell you that your email has been verified and that you are ready to go. But that’s where it gets confusing because you aren’t.
-
Now you must go to http://portal.azure.com and set up more things there. If you don’t have an Azure account, you will have to set one up.. You will need to provide a credit card and the whole nine yards. (setting up an Azure account is outside of scope of this article)
-
In Azure Portal, click on the “+”, type in “Cognitive” in the search box and then click on Cognitive Services API (Preview) below
-
You can then populate your Account name, Subscription, API Type – Use Text Analytics API (Preview), pick your location, Pricing Tier (F0 is free for up to 5,000 calls) and then your resource group
-
After this, resource is created, you can open it up, go to Keys and grab one of the two keys there (as in copy it to your clipboard)
-
Now you can create a connection in Flow manually using this API Key to connect to your Cognitive Services Azure resource or you can pick one of the templates in flow that use Text Analytics or create a Text Analytics step as a connection to the Tweet processing step and enter the Text API Key at that point.
business intelligist 