Optimizing cognitive services use in Power BI

[ispajic]

Hi, I have a question. I've started making sentiment analysis in PBI using Cognitive services. However, I'm afraid that every time I get in more data and perform the sentiment analysis, all of the data gets analyzed, including the one I already have results for. Since Cognitive services charge by numbers, this could lead to extreme increase in costs. Is there a way to limit it so that only new data is sent ot cognitive services?

[v-juanli-msft]

Hi @ispajic 

"Is there a way to limit it so that only new data is sent ot cognitive services?"

It seems you mean to limit data which is imported to cognitive services from Power BI. Right?

Based on my understanding, there are two possiblities, please correct me which is correct.

1. when refreshing data which is imported into Power bi, you need to limit the data refreshed.

2.after creating sentiment analysis in Power BI, then send the analysis data to cognitive services, you need to limit this data. 

Best Regards
Maggie

[ispajic]

Hi Maggie,

I guess option 2 is the right one, because I want all the data in my PBI.

How do you limit option 2?