Limitation when use DirectQuery

[harshaSampath81]

What are the Main limitations when use DirectQuery?

[v-sihou-msft · Accepted solution]

@harshaSampath81

There's some DAX compatibility limitation in Direct Query. See: 

DAX Formula Compatibility in DirectQuery Mode

And some transform function, like FORMAT() is not supported under Direct Query mode. Since you connect the data source directly, it doesn't allow your modify the source data. So transform steps is not supported in Query Editor. 

For other limitataions, please see: Use DirectQuery in Power BI Desktop

Regards,

[hi_world]

Hello, 

This link doesnt work : DAX Formula Compatibility in DirectQuery Mode

Can you please give us the right link ? 

Thanks

[harshaSampath81]

I want to know Why NQL in Dashboard not supported when we use Direct Query Mode ?

Harsha

[bajee]

Hi,

If your using Direct query connection you can not perform the calucations using DAX.

Regards,

Bajee.