How to update Oracle data source connections without losing the report structure

[FabioF]

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.

[amitchandak · Accepted solution]

@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 pipeline

Premium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0

[FabioF]

That works as I wished! Thank you! 😉