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 (1)
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.