Is there any way to improve my azure db connection speed?

[Anonymous]

Currently I create a report using [direct query] azure sql database. When I use direct query its just very slow it takes a couple minute just to load the simple data for a simple matrix. any way as end user I can improve this speed? the data table is relative big.

Since I was not able to improve the connection speed  I change to connection to import. With this I am satisfied with the speed.

 My problem is the following: the data In the azure sql database refreshing every day, and I would like to update my imported data with the yesterday data. So currently I import everything that cover the period of 2020jan1 till 2020 jul 13 Monday. Today 16 jul I would like to refresh my data that cover the jul13-jul16 data only. Is there any way to retrieve 3 day data and add my existing model? How should I do that? if I click power query I still see my original query where I retrieved the 2020jan1-2020jul13 data. is there  formula that cover today-my existing data? if yes what is that formula? 

thank you

[amitchandak · Accepted solution]

@Anonymous , is incremental load is not a option ?

Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/

or like this

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

other docs

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/