Promoting Data Marts in Power BI
Power BI is Microsoft’s data visualization solution

Once you have created a data mart, and your colleagues have access to it, it will be available as a Power BI dataset.

The problem is, every report that you publish and/or is shared with you will also be available as a dataset. How do distinguish data marts from regular datasets?

You can signal to your colleagues (and your future self) that a data mart is ready by promoting it.

To promote a data mart:

  1. From Power BI Service, go to the Workspace where your data mart is located. Then go to Datasets + dataflows.

    2020-11-05-promote-data-mart-pbi-img01

  2. Locate the data mart you would like to promote. Go to More options > Settings.

    2020-11-05-promote-data-mart-pbi-img02

  3. Click on Endorsement and select Promoted. Feel free to write a description of your data mart for reference. Click on Apply.

    2020-11-05-promote-data-mart-pbi-img03.jpg

The next time that you connect to the data mart, you will see that it now has the Promoted label.

2020-11-05-promote-data-mart-pbi-img04.jpg

In this way, you are able to distinguish data marts from regular datasets.

Promoting Data Marts in Power BI
Older post

On the Reasons to Create Data Marts in Power BI

Saving you and your team priceless time when creating reports for your organization

Newer post

Importing Excel Files from a Personal OneDrive in Python

I saw multiple people struggling with this topic on Stack Overflow. Here is simple and quick way of importing excel data located in a Personal OneDrive into Python

Promoting Data Marts in Power BI