Forum Discussion

blackshep01's avatar
blackshep01
Frequent Visitor
9 years ago
Solved

Data blending with On-Prem Data Gateway

I have a dataset with a table from SQL Server and Oracle.  How would the On-Prem Data Gateway update both tables from two different databases in a single dataset?  

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    blackshep01 The connection type available for this scenario would be "Import" only, but this is supported and should work. You would be using the Power BI Desktop to connect to both data sources. You would create both the data sources on the same gateway in the Service and with the same exact connection strings as your Desktop file. Then when you published the Desktop, the OPD Gateway would be available for you to schedule a refresh on your mixed dataset.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    blackshep01 The connection type available for this scenario would be "Import" only, but this is supported and should work. You would be using the Power BI Desktop to connect to both data sources. You would create both the data sources on the same gateway in the Service and with the same exact connection strings as your Desktop file. Then when you published the Desktop, the OPD Gateway would be available for you to schedule a refresh on your mixed dataset.