|
|
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