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. 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-refresh
I 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,