Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 refresh in Service but it takes about an hour to refresh. This is really causing me issues when i am trying to check quick changes. Its taking me ages to do anything.
Is there any tips you can give me for avoiding the refresh times when I just for example do a tiny amendment on a column
Solved! Go to Solution.
Hi,
Hope this can help:
https://community.powerbi.com/t5/Desktop/Data-Refresh-takes-a-very-long-time/td-p/701298
Best Regards,
Giotto
Hi,
Hope this can help:
https://community.powerbi.com/t5/Desktop/Data-Refresh-takes-a-very-long-time/td-p/701298
Best Regards,
Giotto
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