The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |