Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @Ereid ,
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |