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.

ID-ul proiectului: 39851748