Forum Discussion
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! 🙂
Hi littlemojopuppy ,
take a look at Part 4 - DevOps
https://powerbi.tips/2020/04/tabular-editor-rocks/
2 Replies
- mwegener
Most Valuable Professional
Hi littlemojopuppy ,
take a look at Part 4 - DevOps
https://powerbi.tips/2020/04/tabular-editor-rocks/
- littlemojopuppy
Community Champion
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!