cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Replicating DAX measures and calculated columns in different Database environments

Hello everyone,
I had built a Power BI report pointing to the SQL server database and created DAX columns and measures using the modeling tool and using the query editor in Desktop.
Now I need to migrate the report to connect via the same table structure to the Oracle environment and using Advanced editor option in Power BI Query Editor I was able to easily replicate the changes that I did via query editor but I am unable to find similar setup changes for DAX code written through modeling tool.

I tried reading a couple of documents and solutions but doesn't seem to have a solution that easily replicates the measures and calculated columns.

Does it require to be manually created again?

Did anyone face a similar issue? Any thoughts are appreciated.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Replicating DAX measures and calculated columns in different Database environments

Hi @Nadi_123 

In this case, you can save your original power bi desktop file as a template, it will be saved as a pbit file,

then you can open the pbit file, it will ask for a data source, use the new data source here, finally save this file as a pbix file.

Please see more details below:

https://docs.microsoft.com/en-us/power-bi/desktop-templates

https://community.powerbi.com/t5/Desktop/one-model-to-manage-different-data-source-format/td-p/10910...

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Replicating DAX measures and calculated columns in different Database environments

Hi Team,

 

I tried that option and what I noticed was that I am having a duplicate copy of my existing table and it is not merging with my original table and doesn't have any transformations that I have applied either.

 

So I don't think this solution will work for me in this case.

 

Thanks

Nadeena

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors