Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Gateway with DocumentDB and on premise sql server

I have a dataset that has a connection to DocumentDB and an on premise sql server.  I have an enterprise gateway setup for the sql connection and that works fine.  If i try and schedule a refresh it ...
General Comment
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    I test the scenario as yours and reproduce your issue.

    When I combine on-premises SQL Server data source and online data source in a dataset, I will be forced to use personal gateway if I need to schedule refresh  for the dataset.  This issue has been submitted in the following link and the feature using enterprise gateway to work with online data sources is under review, please vote it. The current workaround  is to use the personal gateway to combine on-prem with online data sources.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

I test the scenario as yours and reproduce your issue.

When I combine on-premises SQL Server data source and online data source in a dataset, I will be forced to use personal gateway if I need to schedule refresh  for the dataset.  This issue has been submitted in the following link and the feature using enterprise gateway to work with online data sources is under review, please vote it. The current workaround  is to use the personal gateway to combine on-prem with online data sources.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

Thanks,
Lydia Zhang