Why PowerBI desktop refresh is faster than service?

[Anonymous]

Hello,

It is just a info question that I couldn't find the answer.

I have two tables that I get from SQL one is around 70k rows other one is around 3.5 millions.

3.5million table has incremental refresh.

When I refresh the report on Desktop it takes around 20min but when I publish to app(web) when I refresh it takes more than 1 hour(for first refresh) why is that?

Thanks for any comment

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[amitchandak · Accepted solution]

@Anonymous , where is you gateway setup, Same Desktop or you are using a cloud DB.

If the Gateway is on the same desktop, it is adding the work on same machine + data network delay

[harshnathani]

Hi @Anonymous ,

One of the reson maybe.

Desktop is on your local machine. Service is on the cloud. So the speed of connectivity matters.

https://docs.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop

https://community.powerbi.com/t5/Desktop/BI-web-vs-desktop/td-p/3736#:~:text=Re%3A%20BI%20web%20vs%20desktop,-Mark%20as%20New&text=One%20big%20difference%20is%20that,the%20Desktop%20you%20do%20not.

Regards,

Harsh Nathani