cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harshaSampath81 Helper II
Helper II

Limitation when use DirectQuery

What are the Main limitations when use DirectQuery?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Limitation when use DirectQuery

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

 

View solution in original post

3 REPLIES 3
bajee Resolver III
Resolver III

Re: Limitation when use DirectQuery

Hi,

 

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

 

Regards,

Bajee.

Microsoft
Microsoft

Re: Limitation when use DirectQuery

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

 

View solution in original post

harshaSampath81 Helper II
Helper II

Re: Limitation when use DirectQuery

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

 

Harsha

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors