Schedule refresh of data obtained by API

[Syndicate_Admin]

Good to all!!

As I read in the PowerBi documentation, it is not possible to schedule an update of projects that use calls to an API to get the data because these are dynamic. For now, as much as I search, I can only find a way to have to update the data manually in the Desktop version, and then publish the project.

The calls I have are of the type:

let
    Origen = Json.Document(Web.Contents("https://api.mabrian.com/v1/airdata/searches/total_evolution?lista_paramatros=<parametros>&key=<key>")),
    ........
in
  ....

Isn't there really any "trick" or patch that can fix that can update that data on a regular basis??

Thank you very much in advance.

[Syndicate_Admin]

Unfortunately, there is no further way down that road. Thank you very much anyway for the help.

[v-yetao1-msft]

Hi @Syndicate_Admin 

I found an introduction about update schedule refresh API ,maybe you can refer to it

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updaterefreshschedule

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.