Forum Discussion

GuySev's avatar
GuySev
Advocate I
7 years ago
Solved

Data Refresh takes a very long time

Hello all,   My apologies if this subject has been already on this board, I searched for a solution for a while and couldn't find the right answer.   I've built a rather complex model that combin...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    When you do joins/appends in Power Query it has to load the entire table into virtual memory. This causes a lot of paging and is very slow.

     

    Does your dataset have to be refreshed on an approximatly hourly basis or is a daily cadence ok?

    As this will greatly affect what options are open to you to increase performance.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi. I have a similar issue. We consumed data from SAP HANA database where in we created dataflows in Power BI Service. The dataflows we created are refreshing in very lesser time. We consumed the same dataflows in to power BI Desktop and when we move this dataset to service, it is consuming almost 3.5 hours in service. We also enabled incremental refresh in Service on dataflow. So not sure why our dataset is consuming a lot fo time for refresh. Any help could be greatly appeciated.