I have a file with 21,076 rows and 2 columns: “id” and “text”. I am trying to use R scripts to connect to Azure Cognitive Services API and apply Language detection to the “text” column. When I run my...
jrecasens
Advocate I
Advocate IAttached you can find the files:
https://1drv.ms/f/s!ApFP03_iPLLTg44qzx0JTucsro8Unw
You need to change two things: the folder parameter in the .pbix file and also update your API key in the R code. You can create a "Text Analytics API" key here:
https://azure.microsoft.com/en-us/try/cognitive-services/?api=text-analytics
The .pbix has a query that references the R code (code.R file). The resulting dataset (output.txt) should have 9,181 rows but in PowerBI, chunks of data are sent multiple times, as shown in the log.txt output.
To test it in R Studio just un-comment the first lines of code.