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