Forum Discussion
DebbieE
Community Champion
6 years agoDataflows and refreshing to check changes
I have created a dataflow Every time I do any small developments and then go back to Desktop to refresh, the new column comes through but it doesnt have any data in it. I have to go back and ...
- 6 years ago
Hi,
Hope this can help:
https://community.powerbi.com/t5/Desktop/Data-Refresh-takes-a-very-long-time/td-p/701298
Best Regards,
Giotto
v-gizhi-msft
Community Support
6 years agoHi,
Hope this can help:
https://community.powerbi.com/t5/Desktop/Data-Refresh-takes-a-very-long-time/td-p/701298
Best Regards,
Giotto
- DebbieE6 years ago
Community Champion
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.
That will do it then. Im trying to get everyone to move towards a proper data model in a SQL database. Hopefully this is another reason for it