Solved: unable to refresh power bi online dataset from sal...

garyhow01 · ‎07-06-2017

hello,

we are unable to schedule refresh on our dataset on power bi online.

the dataset/model is a fusion of data from Salesforce Objects(using SF connector), and on-prem SQL DB (using data gateway).

Individual datasources can be refreshed without any issue, its only when combining the 2 datasources into 1 dataset/model, then the problem of not being able to refresh arises.

hope any one can help,

Thanks,

G.

v-haibl-msft · ‎07-06-2017

@garyhow01

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 on-premise data gateway (personal mode).

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

Best Regards,
Herbert

View solution in original post

v-haibl-msft · ‎07-06-2017

@garyhow01

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 on-premise data gateway (personal mode).

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

Best Regards,
Herbert