Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I just want to ask something with regards to DAX calculation performance. Currently, we are using Azure Analysis Services to host our model, and our PowerBI report has a live connection to it. Some of our DAX formulas are hosted in AAS, while some our in the PBIX file.
Is there any difference in the performance of the DAX formula that is in AAS versus the one in the PBIX file locally? Or will both be processed in the AAS server since the model is there anyway?
Solved! Go to Solution.
@daxer-almighty I see. But is there anyway I can trace this? How can I know that it is my AAS server that is processing my DAX measure, and not the PowerBI Premium Service?
@jsnbravo - That is an interesting question. So are you saying that you have a measure that you created in your PBIX file that is connected to your SSAS live instance and you want to know if the calculation of the measures actually takes place on the SSAS instance, Power BI Desktop or both, correct?
@Greg_Deckler Yes, you understood my question clearly. Basically, I want to know if we are leveraging our AAS to perform all processing/calculation even though the DAX measure is in the PBIX file.
To add context also, my report is hosted in a Premium workspace. How will I know if it is my AAS, and not the Premium capacity, that is performing the calculations?
@jsnbravo , ideally there should not be as excution should happen at AAS server.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |