Hi everyone,
I’m coming across some specific drawbacks of using the semantic models in TimeXtender in combination with PowerBI. I hope this is due to my lack of understanding or design choices and hoping it can be fixed.
While working OT(A)P (DEV / TST / PRD) we have found that looking at the development environment with PowerBI is too much of a hassle, too many changes, wrong data, just too much development to keep up in the semantic models and PowerBI is not flexible when it comes to name changes etc.
We decided to delete the semantic models from DEV and start building the model in TST. (For early data exploration we can still build the model in PowerBI itself on the MDW). In PowerBI we use the pipelines and we can connect TST-TST and PRD-PRD. But what would be even better is connect a PowerBI DEV workspace to TST, and the PowerBI TST and PRD workspaces to the PRD endpoint so that we can test the dashboard on production data, give it the green light and there is no risk of any differences when promoting it in PRD, no downtime etc.
Is it possible to connect 1 semantic model to multiple workspaces? Also, can I create multiple of the same type of endpoints so that I can have the same dataset in multiple workspaces? If not, is there a way to publish these datasets somewhere else and then connect to that like an intermediate layer or something?
I hope I’m missing something or someone figured out a nice solution already.
Tnx,
Pepijn
