All,
I am new to the community but not new to PBI. We have been using it at my company now for a few years in tandem with our Microstrategy Enterprise BI. We love PBI but for us, there is one key piece missing. In Micorstrategy, you create the equivalent of 1 master dynamic semantic model through the creation of objects that can be tied to several tables. Then reports and datasets are build from these objects and generate dynamic joining logic for those tables based on the setup of the objects and their relation to other objects on the report. there doesn't appear to be any similar functionality in PBI. We find this functionality to be crucial to be able to extend self service BI to people who do not understand data modeling and how joins effect data. Without this we would have to send over 1000 users through some training on data modeling. In addition, this style of semantic modeling adds some degree of governance that keeps our self service users from creating joins that remove, duplicate, or otherwise alter the dataset in unintended ways that may create inaccurate reports that are not obviously wrong to the end user.
My request to this community is to provide some help in how to overcome this gap in PBI. If you or your company have made the switch with self service BI from Microstrategy to Power BI, how did you deal with this gap? Any help would be appreciated!
