Forum Discussion
Scheduled Refresh Custom Function
It looks like you may be running into the issue I describe here:
Can you try rewriting so that Web.Contents uses the Query option for your parameters?
Chris
Ah, I didn't see that you are doing authentication using a header - no, I don't think it will work (see the comment by danzrust on the blog post). Sorry!
Chris
Hi Soldexio,
Your scenario is similar as below, it need to analytics response data to invoke them to get next data.
How to perform loop in M Query and collate result of the same
It is a loop operation which only suitable with custom functions so you can't use it on power bi service side.
>>Could you elaborate what you mean with manually write custom steps?
If your query has fixed request frequency, you can manually write custom steps to invoke api and analytics response data.
If frequency are dynamics and you can't confirm how many times it invoke, my suggestion not works for this scenario, you had to use custom function to achieve these operations and can't works on service side.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Cheers for the elaboration, I have these working in Power BI desktop, however they do not work in services and scheduled refreshes. Therefore, this cannot be used in our case but I believe that concludes that this is not possible in Power BI sadly.
Thanks for the replies.