Forum Discussion
Post PartisanDirect Query
Yes, you can. In DirectQuery you won't see the Data view, but you can still right-click the table in the Data pane and pick New column.
The catch is that it has to be a row-level expression that can be pushed down to the source, meaning it can only use other columns from the same row of that table, no aggregations. Functions that can't fold just won't show up in autocomplete.
Docs: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Hope this helps!
https://www.linkedin.com/in/richard-ampie-218a07247/
Kudo CommanderYes, you can. In DirectQuery you won't see the Data view, but you can still right-click the table in the Data pane and pick New column.
The catch is that it has to be a row-level expression that can be pushed down to the source, meaning it can only use other columns from the same row of that table, no aggregations. Functions that can't fold just won't show up in autocomplete.
Docs: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Hope this helps!
https://www.linkedin.com/in/richard-ampie-218a07247/