Power BI with Dual Databases

I’m midway through a Power BI Pro rollout that must draw data equally from Oracle 19c (on-prem) and MS SQL 2019 . The core challenge is to sync data between the two servers, then surface it inside Power BI—mainly as high-performance Tables/Matrix reports.

What I need from you
• Configure secure gateways and credentials so Power BI can query both databases in real time.
• Write and tune SQL and PL/SQL that replicates data between Oracle and MS SQL without breaking referential integrity.
• Build an efficient data model in Power BI, create the required table/matrix visuals, and publish a workspace I can maintain.
• Document every connection, refresh schedule, and maintenance step so hand-over is seamless.

You’ll get VPN access, test credentials, and a clear schema map once we sign an NDA.

When you reply, focus on relevant experience—especially projects that blended Oracle and MS SQL inside Power BI or similar BI tools. A concise summary or screenshot of past work is all I need; no lengthy proposal required.

If you’re comfortable juggling both databases and squeezing every millisecond out of Power BI, let’s talk.