Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Raj_293
Regular Visitor

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
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.