exhaustive list of usage limits for measures and columns calculated in direct query mode

[hi_world]

Hello, 

Can you please tell me what is the list of usage limits for measures and columns calculated in direct query mode ?

Thank you

Best regards

[amitchandak]

@hi_world , A few which I can list, other than what is given here

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

1. You can only create simple columns like addition subtraction and conditional etc.  - Both DAX /Power query

2. Change data Type is limited in power query

4. You can not do any across row operation or one which changes table structure - Pivot, Unpivot , Tranpose , split column etc

5. In DAX other than related functions, across Table and row operations are not supported in DAX New Column

6. Most of the measure functions are allows

7. There is special function combinevalues to do multi column join

https://learn.microsoft.com/en-us/dax/combinevalues-function-dax

There limit line not more than 1M rows for results etc,

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

Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow