Forum Discussion
How to update Oracle data source connections without losing the report structure
Hi everyone,
I have finished building a report with Power BI Desktop that is connected to an Oracle Database in a test environment. In my .pbix file, I have already created not only the presentation part with visuals, but also the relationships, measures, calculated tables, etc.
Now, I need to update the data source so that it points to a mirrored production environment (still an Oracle Database, with the same tables, same fields, even at the name level). Is there a way to do this quickly without losing all the structure of the report I have produced so far? I would like to avoid having to recreate the report from scratch by manually copying from the existing one.
Thank you very much in advance.
FabioF , If you want on desktop, just change the connection using Data Source setting (Under Home Tab -> Transform Data -> Data Source setting)
How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY
If you are a premium customer, use the deployment pipelinePremium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0
2 Replies
- amitchandakSuper User
FabioF , If you want on desktop, just change the connection using Data Source setting (Under Home Tab -> Transform Data -> Data Source setting)
How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY
If you are a premium customer, use the deployment pipelinePremium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0
- FabioFFrequent Visitor
That works as I wished! Thank you! 😉