Power BI Online Report Refresh Slow

[acp8888]

I have a report built using an import data set from a cube. In Power BI Desktop, this report takes around a minute to refresh. When I publish this report to an App Workspace, it takes over 40 minutes to refresh. The report has some fairly complex DAX logic but I'm having trouble identifying why this would take so much longer to refresh online versus in the desktop version. Any ideas?

[Anonymous]

The Report in Service uses the Gateway in order to connect to Data Source. The Installed Gateway should be close to the Data source if not you will have Network Latency between the Gateway Installed Machine and Data Source, that may slow down your processing time.

I think live connected report would be much better instead of Import mode from the cube. 

[acp8888 · Accepted solution]

Thanks for the response! After some more digging I found that the report refreshes once upon upload, then after that it fails due to an "internal service error". I was able to find a few threads with people facing this problem and seems like the only fix was to re-install or restart the gateway.