Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aditya5460
New Member

Direct Query

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.