ODBC connection with scheduled refresh

[mcam0087]

We are creating a hospital lab dashboard and the only hurdle we are facing currently is the manual refresh of data and it is cumbersome. Is there a possible workaround to setup a scheduled refresh in an ODBC connection to a hospital lims database? Thanks. 

[v-xiaoyan-msft]

Hi @mcam0087 ,

You can indeed connect to this data source and then configure scheduled refreshes for it.
If it is for dashboard data, you can also configure automatic page refreshes.

Data refresh in Power BI 

Configure scheduled refresh 

Automatic page refresh in Power BI 

Best Regards,
Community Support Team _ Caitlyn

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

[mcam0087]

Hi Caitlyn,

Thanks for your reply. However at the moment the option is greyed out. Do I need a gateway to overcome this?

Thanks,

Mark