Forum Discussion
Slow excel performance
We currently are using a model on a P1 capacity that performs very quickly in Power BI desktop but a lot of our users want to use Excel which performs really slow when using multiple dimensions. We h...
Thanks for the response! When you are suggesting users use DAX I am assuming you are having them use power query to get what they need?
We are really trying to push users to use power bi for their data exploration but there are always Excel hold outs.
No, Power Query uses M and is generally not accessible to report users. DAX is the language to query datasets.