Thursday, September 1, 2022

Power BI Datamart = Dataflow + Data warehouse + Shared Dataset?

                                                                                                                      Check list of all posts


 

Datamart

Dataflow

Shared Dataset

Output

Azure SQL database

ADSL2, csv file

Memory,
support DAX

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
+ Data warehouse
+ Dataset

Dataflow

Dataset

Flexible architecture

Yes

No

No

Suitable Data size

Middle size

Small size

Enterprise
or Large size

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



No comments:

Post a Comment