Solved: Data blending with On-Prem Data Gateway

blackshep01 · ‎04-10-2017

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?

Seth_C_Bauer · ‎04-10-2017

@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.

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Seth_C_Bauer · ‎04-10-2017

@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.

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Data blending with On-Prem Data Gateway

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024