Forum Discussion
Schedule Refresh and Incremental refresh
Hi. If you were able to connect power bi desktop directly to postgres without installing any additional component, then you might be able to just go to the semantic model settings and schedule refresh.
However, data bases hosted at AWS might not be that straight forward. If you could configure like that it might need a Power Bi onpremise data gateway client on a AWS EC3 (VM) to let it communicate with the database and powerbi service to help on the refresh. That way you could schedule refresh like this:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refreshI would start with that. Incremental refresh is a whole other world that you need to modify your current development (pbix file) and your source tables should have capabilities like "modifiedDate" in order to make it work. https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
I hope that helps,
Hi ibarrau
Thanks for your response!
Does this schedule refresh option present on Power BI service will refresh the data extract?
I mean to say the data present in model as an extract will be refreshed wiht the latest data using this refresh option.Could you please confirm this ?
Regsrds,
Kunal
I'm sorry but I don't understand the phrase "refresh data extract". What do you mean with extract? the docs and the idea is to configure a refresh that will update all data in the model. Your data model will be refreshed completely. Like the refresh button at power bi desktop.
If this is not clear please add more details about "this data extract".
I hope that make sense