Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
What are the Main limitations when use DirectQuery?
Solved! Go to Solution.
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,
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
Hi,
If your using Direct query connection you can not perform the calucations using DAX.
Regards,
Bajee.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |