Scheduling data refresh for power bi report with dynamics online and excel as data sources

[Gagan44]

Hello All,

I have created and published power bi report that has two queries  - one for excel (from the local system) and another for Dynamics Online. Can any one please help how to schedule refresh for the above two data sources in Power bi Service.

I have read some threads which says we cannot schedule refresh through gateways if we have two seperate queries that connects to on-premises and cloud data sources. Is this correct? or is there any way we can schedule refresh for this scenario? 

Thanks in Advance for any help!!

[v-gizhi-msft]

Hi,

Hope these can help:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 

And some data sources do not need configure gateway, see this:

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources 

Best Regards,

Giotto

[Greg_Deckler]

Try the gateway installed in Enterprise mode first. If that fails, try installing the gateway in Personal mode. In the past, Personal mode always tended to work for mixed on-premises and online resources.