This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
We have two SSAS tabular model environments setup identically, Development and Production. Each has one model with some perspectives.
The issue is when we design a new report over a perspective in development and then promote it to production by changing the data source settings, the perspective doesn't keep, and instead, it loads in all the Dimensions and Facts under the fields section.
Is there a way to maintain the perspective when migrating or put back the perspective after we migrate?
Thank you in advance!
Hi @jdonais ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
Best Regards
Lucien
Hi @jdonais ,
You could read the following article ,wish it is helpful for you!
Perspective in a Tabular Model recently broken for anyone else?
Deploying SSAS Solutions From Dev to Prod Environment
Migrate SSAS Tabular from Dev to Prod
Best Regards
Lucien
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 61 | |
| 36 | |
| 29 | |
| 22 | |
| 21 |