Azure Text Analytics

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!