Incremental Refresh Stuck

[jaideepnema]

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 ?

[Icey]

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.

[amitchandak]

@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=mGnNn6gnrKk

Log an issue if needed at  -https://community.powerbi.com/t5/Issues/idb-p/Issues

[jaideepnema]

@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.