Hi @SwathiSBellad ,
Dataflows provide reusable extract, transform and load (ETL). Tables can't be browsed, queried, or explored without a dataset, but can be defined for reuse. The data is exposed in Power BI or CDM format if you bring your own data lake. Dataflows are used by Power BI to ingest data into your datamarts. You should use dataflows whenever you want to reuse your ETL logic.
Use dataflows when you need to:
- Build reusable and shareable data prep for items in Power BI.
Datamarts are a fully managed database that enables you to store and explore your data in a relational and fully managed Azure SQL DB. Datamarts provide SQL support, a no-code visual query designer, Row Level Security (RLS), and auto-generation of a dataset for each datamart. You can perform ad-hoc analysis and create reports, all on the web.
Use datamarts when you need to:
- Sort, filter, do simple aggregation visually or through expressions defined in SQL
- For outputs that are results, sets, tables, and filtered tables of data
- Provide accessible data through a SQL endpoint
- Enable users who don’t have access to Power BI Desktop
For more details, you can read below document:
Introduction to datamarts - Power BI | Microsoft Learn
Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn
Dataflows with benefits – BI Polar (ssbipolar.com)
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
