Azure Text Analytics

[Ereid]

Hi All!

I need to run some survey results through Azure's Text Analytics API.  I have an Azure account, the Power BI workbook is setup, and everything is running smoothly, and running smoothly, and running smoothly. 

My survey results are a static dataset.  Once I do the initial API call for key phrases and sentiment analysis I don't want Power BI to perform the call again.  It seems that Power BI runs the call once while setting up the query, and again when you save the query and load.  It reruns the call every time you make a modification to the query that performs the call. 

Does anyone know how to limit Power BI to one API call while still maintaining a functional query?  If I pull the API key from the process then my datasets show errors, even though they are populated. 

Any help would be appreciated! 

[mwegener]

Hi @Ereid ,

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Ereid ,

look at this...

https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/

... and maybe this could help

https://docs.microsoft.com/en-us/powerquery-m/table-buffer

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.