I have created a "master" semantic model for my company's sales data as it is very large, takes a long time to load, and contains many columns that need to be organized. I am now attempting to build multiple reports using this semantic model as the data source for said reports. Each report requires different groupings and calculations that likely will not be needed in any other reports. I am attempting to create new groups/calculated columns within each report, however, I cannot seem to find a way to do this if I use an existing published semantic model. I would really like to avoid having to load and organize the data anew each time, but also do not want unnecessary/unrelated groups and calculations clogging my main semantic model.
I am more familiar with Tableau - where you can pull a Tableau Data Source from the server, then create groups, calculated fields, etc just for a single report/workbook . For example, I have a calculated field for a client's ranking in terms of opportunity that I need for a specific opportunity rankings dashboard, but I don't need that field to appear in any other dashboard. If I create a calculation in my opportunity rankings dashboard, then open another blank report, all of the datasource's calculated fields will be available, but the report-specific ones (such as opp rank) will not be included in the blank report.
Is there any way to achieve this in PowerBI with a semantic model built on redshift data? Thank you.
