Forum Discussion
Resolver IDatamart
I was always intrigued (and appalled) by the concept of Direct Query access to Dataflows. Maybe that is what Datamarts are. That would explain why that "Do you want to create a Datamart instead" question keeps coming up.
Resolver IThank you for your answer.
I checked now if I can create something (table, view) in the SQL server database of a datamart via Azure Studio or SSMS. This does not work and is consistent with your explanation. So I would characterize it roughly as a "read only SQL database with a Power BI front end for reporting in a specific domain". Someone can correct me if this working definition is too narrow.
The MS documentation says:
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
Best regards
Christian
Super UserI was always intrigued (and appalled) by the concept of Direct Query access to Dataflows. Maybe that is what Datamarts are. That would explain why that "Do you want to create a Datamart instead" question keeps coming up.