Cannot refresh via Gateway when on premise and cloud based exit in one report

[kyle705]

We have recently has an enterprise gateway installed on a server. All seems to be peachy for reports that are created from purely on premises data.

Problem: I cannot initiate auto refresh via gateway when local on premises data (e.g. excel, access, SQL Server) is mixed with cloud based data (e.g. access web app stored in SQL Azure).

Please can the ability to auto refresh be enabled for mix source reports?

[v-haibl-msft]

@kyle705

Please refer to this article. Currently, on-premise data gateway doesn't support OAuth2 based authentication. We are not able to add the online data sources in data gateway as well as on-premise data sources, so that we can't configure this kind of combined dataset to use data gateway. The workaround is to use personal gateway.

PG have started working on the data gateway to fix this issue. See: Combine enterprise gateway and online data sources.

Best Regards,
Herbert

[kyle705]

The article suggest the PG is being worked on first, followed by the EG. Any ETA on both?

[v-haibl-msft]

@kyle705

As far as I know, there is no ETA for them yet. We can keep on eye on the status in https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew....

Best Regards,
Herbert