Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
harshaSampath81
Helper II
Helper II

Limitation when use DirectQuery

What are the Main limitations when use DirectQuery?

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@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

4 REPLIES 4
v-sihou-msft
Employee
Employee

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

 

Hello, 

This link doesnt work : DAX Formula Compatibility in DirectQuery Mode

Can you please give us the right link ? 

Thanks

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

 

Harsha

bajee
Resolver III
Resolver III

Hi,

 

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

 

Regards,

Bajee.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.