Adding More DAX Commands for Calculated Columns with Direct Query

[pseiler]

Hello all, 

 I am trying to do some analytics with R in Power BI, and it would be really nice if I could have some calculated columns to allow me to filter my R Visual.  With that being said, the current data we are drawing in is via direct query, and consequently the DAX commands which I can use to generate calculated columns are limited.  I was wondering what the timeline was in terms of when more DAX functionality will be allowed with Direct Query and calculated columns.  Thanks! 

[v-haibl-msft]

@pseiler

There is not specific timeline for it. The reasons a particular function might not be optimized for DirectQuery is because the underlying relational engine cannot perform calculations equivalent to those performed by the xVelocity engine, or the formula cannot be converted to an equivalent SQL expression. In other cases, the performance of the converted expression and the resulting calculations may be unacceptable.

So it should not be a easy job. We can keep an eye on the related document like https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-d....

You can also create an idea in https://ideas.powerbi.com to push it.

Best Regards,
Herbert

[pseiler]

I see. That's unfortunate. I'll keep an eye on that related document though, and create an idea. Thank you!