|
Datamart |
Dataflow |
Shared Dataset |
Output |
Azure SQL database |
ADSL2, csv file |
Memory, |
ETL/ELT |
Yes |
Yes |
No |
Data Model |
Yes |
Yes |
Yes |
Power BI desktop needed |
No |
No |
Yes |
Power BI service needed |
Yes |
Yes |
No |
Shared with different workspaces |
Yes |
Yes |
Yes |
Composed of |
Dataflow |
Dataflow |
Dataset |
Flexible architecture |
Yes |
No |
No |
Suitable Data size |
Middle size |
Small size |
Enterprise |
Add new column |
No |
No |
No |
Add new measures |
Yes |
not applied |
Yes |
Support SQL |
Yes |
No |
No |
Support DAX |
Yes |
No |
Yes |
Role level securty |
Yes |
not applied |
Yes |
Only support premium capacity |
Yes |
No |
No |
Can be used as relational database |
Yes |
No |
No |
Thursday, September 1, 2022
Power BI Datamart = Dataflow + Data warehouse + Shared Dataset?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment