Forum Discussion
Where does DAX run for published dashboard?
- 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.
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.