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 not sure what you are asking. I can say that once the sources are configured (with only cloud credentials or the onpremise data gateway) a refresh at PowerBi Service it's like clicking "refresh" at the power bi desktop.
I hope that make sense