Please enable JavaScript.

Coggle requires JavaScript to display documents.

Power BI's connectivity, DAX (Calculation, Time series, Hierarchy data…

- - - - Open Database Connectivity
        :arrow_right: NoSQL ex Cassandra
      - Relational database
- - - - Table Storage mode
        
        Import: cached data
        
        Direct Query: fast access + no cache
        :check: live data
        :check: no need to refresh
        
        Dual
      - Partition of a composite table
        hot data --> import table
        history --> direct query
    - - :no_entry: disable Load query to model
- - - - DAX userprincipalname
        same results in PBI desktop and service
      - DAX username
        PBI desktop Domain\User
        PBI service user@domain.com