Forum Discussion

JordanAdam98's avatar
JordanAdam98
Regular Visitor
1 year ago
Solved

Where does DAX run for published dashboard?

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 expressi...
  • speedramps's avatar
    1 year ago

    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.