Regarding Azure Text Analytics Free API limit

[akj2784]

I am using Azure Text Analytics API to get the sentiment score and key phrases in power BI. I have 500 tweets in the file. But when I call the funtion to get score and keyphrases for each tweets, I can see the transaction went beyond 2200. I just want to understand the reason behind this. I know there is free limit of 5000 transactions per month. Also whenever I go to edit query to create any new column or apply some logic, it will again process the same records and the trasanction will increase further. Is this the expected behaviour or something needs to be done to avoid the re execution of function to get sentiment score.

What is the best way to utilize this transaction limit.

Regards,

Akash

[v-chuncz-msft]

@akj2784,

You may take a look at Data refresh in Power BI.