Forum Discussion
repointing a SQLServer based dataset to Oracle
Our Data warehouse is being migtrated from MS SQL server over to Oracle Exadata. While the entities within the data model are remaining the same. for example, some table and field names are being s...
Hi,
As far as I know the whole extraction generates under the scene, code in M language that you should see using the "advanced editor". Then you would have to change https://learn.microsoft.com/en-us/powerquery-m/sql-database to https://learn.microsoft.com/en-us/powerquery-m/oracle-database to switch from SQL Server to Oracle.
P.S. : if you prefer the UI you also have "Data source settings" but from a quick try it seems you can change the server/db name but not to change the kind of source itself.
Added: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor
Hope it helps.