cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raj_293
New Member

Power Bi - Datamart Layer Between Datasets and Database.

Hi All , 

 

We are building a Datamart layer inorder to avoid the datasets refreshing the same common tables multiple times.

 

current arch-

Database(snowflake) - Datasets - PBI reports

Proposed -

Database(snowflake) - Datamart - Datasets - PBI reports

 

We have around 7-8 datasets (on which multiple reports are built) hitting the database directly . We are building a datamart layer between DB and these datasets so that the tables common in these datasets can be moved to datamart and hence instead of the same tables hitting the DB three/four times it gets refreshed once in- the datamart layer and then caters to the datasets as we replace these tables to point to DM instead of Database.

 

Questions-

1. If a dataset has 10 tables and only 5 are replaced with the ones in Datamart , when the dataset is refreshed(post DM refresh) will the tables pointing to datamart refresh again or not? Only the tables pointing to DB refreshes?

 

2. How do we change the settings to point the datasets from DB to datamart?

 

3. How about the folder structures and hierachies specific to datasets ? Would they have to be recreated in the DM as well?

 

3. If a fact table(Ex- fact sales) common across many datasets has measures specific to the dataset and cannot be moved to the datamart fully with all measures across all datasets , I will not be able to replace the full table with the datamart. Some calculations will still be specific to the dataset. In such cases how does the refresh work? After table is refreshed in Datamart , will calcualtions in the dataset be refreshed again during dataset refresh ?

 

I'm assuming the table will be repointed to the Datamart and those calcualtions which are specific to the Dataset will have to be recreated in the dataset and replace only the common ones created in DM?That way , I will still save some refresh time ?

 

Please advise.

 

Thanks

 

 

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Raj_293,

#1, It should be based on your dataset refresh settings that you host in Datamart. If you not enabled incremental refresh on your data source, the table records will be replaced even if they not updated.

#2, I'd like to suggest you refer to the following 'get start' document of Datamart.

Get started with datamarts (preview) - Power BI | Microsoft Learn

Understand datamarts (preview) - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @Raj_293,

#1, It should be based on your dataset refresh settings that you host in Datamart. If you not enabled incremental refresh on your data source, the table records will be replaced even if they not updated.

#2, I'd like to suggest you refer to the following 'get start' document of Datamart.

Get started with datamarts (preview) - Power BI | Microsoft Learn

Understand datamarts (preview) - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.