On the Reasons to Create Data Marts in Power BI
Power BI is Microsoft’s data visualization solution

A data mart is a central repository for all tables, formatting and relationships you need to create reports.

With a data mart, there is no need to query data every time a new report is created. All required data for your reports is queried within the data mart already.


Power BI Setup Example without Data Mart

Using a data mart also guarantees consistency of definitions and data updates across reports.


Power BI Setup Example with Data Mart

Depending on the size of your organization and the data it handles, creating more than one data mart can be useful. For instance, you may create a data mart for sales while creating another for marketing.

In Power BI, a dataset can be used as a data mart. To create a data mart in Power BI:

  1. Create a report with all tables intended for reporting. Make sure columns are formatted, and the correct relationships are created. No visualizations are needed.


  2. Publish the report by going to Home > Publish. Select the Workspace where the data mart will reside. Make sure to save the data mart under a meaningful/relevant name.


That’s it! To connect to the data mart when creating a new report:

  1. In a new report, go to Home > Get data > Power BI datasets.


  2. Select the data mart you are connecting to. Click Create.


Make sure that your colleagues have read access level to the data mart. Keep in mind that this strategy only allows you to create measures in your report. To create new tables and columns, refer to the data mart itself.

On the Reasons to Create Data Marts in Power BI
Older post

Datasets vs Reports in Power BI

And the importance of distinguish the one from the other.

Newer post

Promoting Data Marts in Power BI

And make them stand out from all other datasets in your account

On the Reasons to Create Data Marts in Power BI