I have a database in SQL with two million records. From Power Query, I’ve done two queries to decrease the refresh time.
Pre-Sales 1/1/16 table
Table back Sales 1/1/16
And then a third append query (SalesTable)
In each query I applied filters:
And then, I disabled for this query, “Enable Load” and “Include in Report Refresh”
For Table back Sales 1/1/16:
and then in the append SalesTable:
In spite of applying these steps, each time the query is updated, each one of them processes all the records of the database, that is to say, the 2 million. This is too slow, is there any way to decrease the updating time?
I found the following article:
But I understand you don’t solve the problem.