Direct Query

[aditya5460]

@v-yangliu-msft @amitchandak @SpartaBI @tamerj1 @Ashish_Mathur @lbendlin    Before i am using import mode and now i want to try direct query mode. So i want to know that in direct query what things that we cant use that we are using in import mode. Which function or dax function or measure we cant use in direct query mode and what are the limitation . I have many tables which are having more than 4 crore thats why i want to use direct query mode.

[amitchandak · Accepted solution]

@aditya5460 , 4 Corer is not a big number for import mode. 40 Million is fine. You need to have a premium P3.

Direct queries do not allow most of the transformations. Only simple transformation are allowed for column, like addition etc.

I have discussed a few differences in 12 videos -

Power BI Decoding Direct Query: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA

Measure are mostly supported with few function exception

refer

https://www.tessellationtech.io/import-vs-direct-query-power-bi/

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery