Showing results for 
Search instead for 
Do you mean 
We are doing a site maintenance. Please note that you may experience some service disruptions during your session. We apologize for any inconvenience caused by that,

The 'How to Guide' to Cognitive Services Text Analytics Macro

The 'How to Guide' to Cognitive Services Text Analytics Macro 


As Microsoft continues to grow it's Machine Learning capabilities, Alteryx is following suit and has built a new connector taking advantage of Microsoft's Cognitive Text Analytics API.


The new Cognitive Services Text Analytics Macro will replace the AzureML Text Analytics Macro, keeping sentiment analysis and key phrase extraction, while also adding Language and Topic detection.


To use this macro you will need to create a Microsoft Account, as well as signing up to the Microsoft Azure Account.


Sign in or create a Microsoft Azure Account and this should take you to the Microsoft Azure Dashboard


Pic 1.png



When on this page click on the green '+ New' symbol and search 'Cognitive Services APIs'



Then click on the 'Cognitive Services API (preview)' and 'Create' button within the window on the right hand side.



You will need to set up a subscriptions if you haven't already. Once you set up an account, you can return to this stage and continue.


Once you have set up a subscription you will be able to generate the cognitive services keys. You can do this by filling out the following window:


pic 2.png


Please select the 'Text Analytics API (Preview)'


Once you have done this you should see the screen below: (If you don't please refresh or sign in & out of cognitive services until you see the information you added above within the information ribbon below).




 Click on the Name of the Account you set up and you should now see two Keys. You can use the first Key within our Cognitive Services Text Analytics Macro.





Copy and Paste your key into the Cognitive Services Macro and select your field and type of text analysis.




 Common Errors:


Error: Invalid subscription key


This error tends to occur because the account hasn't fully been processed by Microsoft.


Solution: Please log in & out of Azure, verify the information looks correct and then copy and paste the key into Alteryx.


Azure Error.png






Jordan Barker

Solutions Consultant

Alteryx Certified Partner
by Alteryx Certified Partner
‎02-09-2017 07:08 AM

Hi @JordanB the new process generates 2 keys and neither seem to work in the macro? Any advice?



by Alteryx
‎02-09-2017 08:51 AM

Hi @joe_lipski


Have you set this up on Azure dashboard as well? I went through the process of setting this up through the text Analytics website, but I also needed to set up Azure and sign up for a free account.


You should then be able to add the account (Screen below)



Once I made sure my account was Active and not Preview, I had to log in and out of the Azure dashboard site! The account then seem to take hold and I chose Key 1.


If you have just set up the account I would recommend logging in and out and using Key 1 again.


Keep me updated.

Alteryx Certified Partner
by Alteryx Certified Partner
‎02-09-2017 09:04 AM

@JordanB All working now! Think it was just a case of logging out and logging back in! Thanks!

by nathan_fredette
‎03-09-2017 11:58 AM - edited ‎03-09-2017 12:20 PM

@JordanB I get the error "The authorization type you provided is not supported. Only basic and OAuth are supported". My account shows active and both keys generate the same error. Any ideas? Thank you.



by Alteryx
‎03-10-2017 12:00 AM

Hi @nathan_fredette


Can you refresh (logoff) Azure on your webpage as we have seen the keys sometime take a while to take hold on the site. 


Can you then insert a new cognitive tool into the canvas and try again.




Jordan Barker

Solutions Consultant

Alteryx Certified Partner
by jamielaird
‎06-12-2017 04:23 AM - edited ‎06-12-2017 04:27 AM

Thanks for this @JordanB 


It worked perfectly for me first time.