How to only run my custom translation function once per value to save quota

[loginerror]

Hopefully I can explain it nicely 🙂

I have a custom translation function that uses an API call to the Azure Translator service. The service allows one to translate up to 2 mln charactesrs for free per month.

The issue I run into is caused by the Power BI auto-refresh of the data set. It eats my quota pretty fast (my source column is a bit short of 1mln characters).

As such, is there a way to tell Power BI to only run my function once for each value and then stop forever (for that value)?

Ideally, I would want it to only apply to one specific data source (I already referenced the values I want to translate in a separate Query that is linked to the source data)

[ToddChitt]

If you want your refresh schedule to be different than that of other queries in your model, then use a Dataflow in your Workspace. However, I can't gaurantee that Dataflows are up to handling the call to your Translation Service. But if it does, then you can schedule it as needed, or not at all. Then in your Power BI Desktop model, you can include the Entity from the Dataflow.

Hope this helps.

[Greg_Deckler]

@ImkeF