topic Re: ODATA Query Refresh - Automatic Option in Power Query

ODATA Query Refresh - Automatic Option

Anonymous — Thu, 21 Jul 2022 18:05:40 GMT

Hello Experts,

I have built a ODATA connection option to extract Data into Power BI. Its asking me manually refresh all the Queries I have built in Power BI Query Editor. How can I make to refresh Automatically OR in the backend to refresh by every 1 hour

Re: ODATA Query Refresh - Automatic Option

lbendlin — Sat, 23 Jul 2022 01:30:27 GMT

Assuming this is an on-premise data source: Set up a gateway, make sure it can see the data source, create a connection, use the connection, set up a schedule.

Re: ODATA Query Refresh - Automatic Option

v-jingzhang — Tue, 26 Jul 2022 09:24:42 GMT

Hi Anonymous

If you want to refresh the queries in Power BI Desktop automatically, I'm afraid this is not available currently. You can vote up the following ideas regarding the similar requirement:

https://ideas.powerbi.com/ideas/idea/?ideaid=db1938b4-2b65-eb11-8fed-281878deecac

https://ideas.powerbi.com/ideas/idea/?ideaid=f08c9abe-315a-4f34-a4c7-e732eff3343a

Best Regards,
Community Support Team _ Jing

Re: ODATA Query Refresh - Automatic Option

Anonymous — Fri, 29 Jul 2022 17:49:07 GMT

Hi Jingzhang,

Thank you very much for your response. I am hosting the dashboards through workspace, In the Workspace, we have an option to refresh through DATASET. Will that work?

Re: ODATA Query Refresh - Automatic Option

Anonymous — Fri, 29 Jul 2022 17:50:29 GMT

Hi Ibendlin,

This is a cloud data source. I am using ODATA connection to download the data. As of now for building the query, I am using Power BI Query Editor, but the dashboard will be hosted in Power BI workspace and the dashboard will be shared to users. as of now I am manually refreshing through Power BI Desktop.

Re: ODATA Query Refresh - Automatic Option

lbendlin — Fri, 29 Jul 2022 19:19:28 GMT

It is only a cloud database if it ca be freely accessed from the Azure service. All other scenarios = on-premise. That includes things like MySQL databases on Azure - you need a VNet gateway. It also includes non-Microsoft ODATA sources - those may need an Enterprise gateway.