Keep historical data in local database to speed up Power BI

[webportal]

Without a premium licensing, is it possible to simulate an incremental refresh to speed up Power BI Desktop?

Say, we keep all the data before a certain date in a local Access database and connect to the "live" database only for data after that date? 
The question is how to export the historical data from one or several pbix file to Access, how can we do that?

[v-yulgu-msft]

Hi @webportal,

Currently, Incremental refresh is only supported by Power BI Premium service. Here is an idea for you to vote.

---

Say, we keep all the data before a certain date in a local Access database and connect to the "live" database only for data after that date? 
The question is how to export the historical data from one or several pbix file to Access, how can we do that?

---

What's purpose to export historical data from Power BI desktop to Access Database? From my opinion, you could export the updated data from source to Access DB each time there existing a refresh. Then, connect to Access DB from Power BI desktop. That way, it would generate multiple queries into desktop. You need to append them manually later.

Regards,

Yuliana Gu