Where are calculations made?

[gustavjMC]

Hello everybody!

I'm using Power BI Service and some of my pages in my report are pretty slow and the common factor between these slow pages is that all of them have some kind of calculation or DAX-Expression in them. It could in some cases be as easy as a simple filter on a table and in other cases more difficult calculations. 

I'm currently trying to optimize this as much as possible, and i therefore wonder where these calculations are made? 

My report is built in Power BI Desktop located on a Cloud-hosted computer, the same place where my SQL-database where I take my data from is. There is also ofcourse a gateway installed on this Cloud-computer so that I'm able to connect to the datasources with Power BI Service. My querys are almost always DirectQuerys and they have to be so because i need real time data.

So to repeat myself, where are the calculations in my report made? Are they made in the SQL-database (sounds unlikely)? Are they made in the Gateway? Or are they made on microsoft's servers A.K.A Power BI Service?

Best regards,

[v-stephen-msft · Accepted solution]

Hi @gustavjMC ,

Measure(Dax) is calculated in Power BI service.

This is Optimization guide for Power BI which you can refer to.

Also I found this blog: My Power BI report is too slow. What tools and techniques should I use? which might be helpful to solve your problem.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.