Forum Discussion

FabioF's avatar
FabioF
Frequent Visitor
2 years ago
Solved

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.

2 Replies