Forum Discussion
GuySev
Advocate I
Advocate IData 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...
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.
Old thread but hope this helps someone else.
When importing data from SQL, in Data Source settings, SQL Server Database connection info, you need to specify the port and not just the SQL server name. Not doing this will slow down the data import by quite a bit
ex: SQLSERVER1, 12345