Power BI

managed self-service BI is characterized by a blended approach that emphasizes discipline at the core and flexibility at the edge.

However, when the core data architecture doesn't include all data required, dataset creators can extend, personalize, or customize existing shared datasets. New specialized datasets can be created that meet business requirements not met by existing centrally delivered datasets. Importantly, there's no duplication of core data. This usage scenario is called customizable managed self-service BI.

Sometimes self-service creators need to augment an existing dataset with, for instance, additional data that's specific to their department. In this case, they can use DirectQuery connections to Power BI datasets

This feature allows for an ideal balance of self-service enablement while taking advantage of the investment in centrally managed data assets. The scenario diagram depicts a DirectQuery connection

Usually, there are many more report creators than dataset creators. These report creators can exist in any area of the organization. Because self-service report creators often need to quickly produce content, a blended approach allows them to focus on producing reports that support timely decision-making without the additional effort of creating a dataset.

The primary objective is for many report creators to reuse centralized shared datasets. To accomplish that, this scenario focuses on decoupling the model development process from the report creation process.

For simplicity, the scenario diagram depicts just one shared dataset. However, it's not usually practical to model all organizational data in a single dataset.

The other extreme is to create a new dataset for every report, as less experienced content creators often do. The goal of managed self-service BI is to find the right balance, leaning toward relatively few datasets and creating new datasets when it makes sense to do so.

hile reports are maintained by subject matter experts in the business units. However, that's not required. For example, this pattern can be adopted by any content creator that wants to achieve reusability.