Can't update or schedule refresh using a m function to load data from Elastic Search

[joabenman]

Hello there, this is my first time working with this tecnology and I had to see If anything can give me a hand with this.

I'm using the function written in this post to load a bunch of data from a internal elastic search server, the only change I did was using two parameters to pass the two first params of the function (they are always the same, I dont have to modify them atleast in this document)

In Power Bi desktop, for now is working fabulous, but at the time to upload the document to the web app I would also like to schedule a diary update like with other documents (or at least a manually update) but the site shows the following error:

Both params have enable load checked, and the data source in case you try to load indepently like a web resource works perfectly, and I dont know what I'm missing

Best regards and thanks in advance, from what I've been able to read through the forum, you're doing a great job.

[v-yuezhe-msft]

@joabenman,

It doesn't support to refresh dataset in Power BI Service when the data access happens inside a function and the data source is dependent on parameters to the function . There is an idea about this issue, please vote it up.

In addition, please check if the workarounds in the following blogs work in your scenario.
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...

Regards,
Lydia