Skip to main content
Microsoft Idea

Power BI

New

Multiple Datasets from a Datamart

Vote (24) Share
Steven Arrington's profile image

Steven Arrington on 28 Sep 2022 16:20:53

My impression is that Power BI Datamarts are being groomed to be a Power BI alternative to the Data Warehouse and Data mart steps in a generic data pipeline.


Here is what I would consider a generic data pipeline:

OLTP Data -> (Optional) Data Lake -> Data Warehouse -> (Optional) Data marts -> Analysis/BI/Reporting


Power BI Datamarts already support an automatic Dataset in Power BI that is then used for reports, my suggestion is to extend this to be able to manually split a Power BI Datamart into several datasets that can then be used in reports, then you don't run the risk of duplicating logic in a separate Power BI Datamart or Dataset and it becomes one place to manage the connections, model, queries, etc.

Comments (2)
Steven Arrington's profile image Profile Picture

Andreu fil on 19 Apr 2024 19:47:23

RE: Multiple Datasets from a Datamart

Good information, thankssehackear.top

Steven Arrington's profile image Profile Picture

Rachael Platt on 02 Feb 2023 16:06:50

RE: Multiple Datasets from a Datamart

This would be very valuable for us as well. We look at data marts as a potential replacement to the dataflow -> dataset process, and with the ability to create subsets of datamarts as individual datasets that would enable us to use them more fully and scale our data.