Forum Discussion

acp8888's avatar
acp8888
Frequent Visitor
9 years ago
Solved

Power BI Online Report Refresh Slow

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?

Need Help
  • acp8888's avatar
    acp8888
    9 years ago

    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. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      acp8888
      Frequent Visitor
      9 years ago

      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.