Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
littlemojopuppy
Community Champion
Community Champion

TEST/PROD deployment of Tabular Data Model

Good afternoon!  Would like to ask for some help with something...this may not even be the right forum for my question.

 

I've created an Azure Analysis Services data model pointed at Production data.  I would like to modify this data model in so that it can point at TEST data and deploy to a TEST AAS database while also still pointing at PROD data and deploy to a PROD AAS database.  Actual deployment of the model to either server should be manual...data refresh on the PROD server is already automated through Azure, and I'm fine with manually refreshing Test data in the model.

 

I've been Googling for a couple hours and looking at what I could find.  It seems that the Configuration Manager might be a means to accomplish this.  I could set up a Development and Production configuration, and each config would point at the appropriate data source and AAS database.  But I'm not positive this is what I need to do.

 

Does anyone have any advice or able to point me to any resources to help me figure out the best way to accomplish this without creating a duplicate version of the data model.  I don't want to have to reconcile changes in TEST to PROD unless that is the only way to get this done.

 

Thank you!  🙂

1 ACCEPTED SOLUTION

Hi @littlemojopuppy ,

 

take a look at Part 4 - DevOps 

https://powerbi.tips/2020/04/tabular-editor-rocks/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


View solution in original post

2 REPLIES 2

Hi @littlemojopuppy ,

 

take a look at Part 4 - DevOps 

https://powerbi.tips/2020/04/tabular-editor-rocks/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Hi @mwegener 

That was very long but very helpful.  Thank you!  My company already has Azure DevOps in place and is how the Product Development team manages work through their pipeline.  Going to talk to someone about getting my team set up.

 

Thanks again!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.