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 slightly modified and a small number of data types are being updated. My question is this.... Is there a method for updating exsiting PBIX files by repointing and remapping of tables & fields in the dataset without having to rebuild the entire UI side of the report?
1 Reply
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.
