Forum Discussion
Incremental Refresh Stuck
I have setup incremental refresh using PostgreSQL as a data source. The file got published to the workspace but when refreshed for the first time on the Power BI Service the refresh is stuck more than 4 hours. Can you please help how this can be resolved ?
Additionally is there any way to stop the refresh using the Power Bi Service ?
3 Replies
jaideepnema , Does it give any error.
Refer in case it is gateway issue
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKkLog an issue if needed at -https://community.powerbi.com/t5/Issues/idb-p/Issues
amitchandak thanks for your reply Amit
I am using PostgreSQL hosted on Azure ie:Azure Postgresql as a data source.....after refreshing for more than 4 hours it throws an Time Out Error.
Hi jaideepnema ,
The first refresh in the Power BI service may take longer to import all data you set to store. Try to reduce that, and set "allow overriding timeouts" in the M expression.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
