Where does DAX run for published dashboard?

[JordanAdam98]

A simple question, I just can't find the answer. Say I have a slider that changes value and a measures value depends on this. Let's say Measure A's value is 2 x Slider Value. Measure A's DAX expression would be something like Measure A = 2 * Slider Value. I now publish this dashboard. From my browser I access this dashboard and move the slider. In my mind either two of the below things are happening:

• The DAX is running in the browser. The browser will do the calculation and will update the measure value. The Power BI service will not be talked to at all.
• Or, the DAX is running in the Power BI service. I update the slider and the new value is sent to the Power BI service that executes the DAX and the measure value is returned to my browser and updated in the dashboard.

Which of the above is correct? If none then what actually happens? I though it was the first one but after trying to research I am now slightly confused about how the whole process works.

Thanks.

[speedramps · Accepted solution]

When you run the report in Power BI Desktop then the DAX calculation are performed by the Power BI Desktop.

However, when you publish the report the dataset and the visual report are published to the Power BI Service.

When you click on slicer the browser will send a request to the power Bi Service, which will perform the DAX calculation and send the results back as HTML.

You can test it as follows:-

• Publish a report to the Power BI Service
• Toggle the slicer and watch DAX calcuate answers
• Disconnect your wifi.
• Toggle the slicer and watch the error message

This is good thing because security access is checked each time,

and the super server cpu does the processing rather than your small laptop.

Please click thumbs up because I have tried to help.

Then click [accept solution] if it works.