Can anyone point me to a summary of how Direct Query works? In particular I am interested in the difference between querying a SQL database and a SSAS Tabular model.
Presumably if I Query a SQL database then I need to create the measures in Power BI as I would normally. If querying SSAS, does Power Bi just pull in the measures directly with no modelling at the Power BI end? If SQL server, how are more complex DAX measures calculated if they use capabilities not in SQL?
Thanks in advance
Presumably if I Query a SQL database then I need to create the measures in Power BI as I would normally. If querying SSAS, does Power Bi just pull in the measures directly with no modelling at the Power BI end? If SQL server, how are more complex DAX measures calculated if they use capabilities not in SQL?
Thanks in advance