cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver II
Resolver II

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 3
Community Support
Community Support

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.

Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

jaideepnema_0-1606136639306.png

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors