Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@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.
Solved! Go to 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
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |