cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

dataflow refresh failing after setting up Incremental refresh

I created dataflow and set up for scheduled refresh, The refresh works fine. But when i changed one of the entities to set up 'Incremental Refresh' the dataflow refresh is failing with error msg below. It looks like time out issue. I refreshed it several times and it is failing exactly after 10 min each time with same msg below

 

'Error: An internal error occurred... RootActivityId = xxxxxxxx-xxxxx-4c02-bcfc-1d328xxxxx.Param1 = Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. '

3 REPLIES 3

Re: dataflow refresh failing after setting up Incremental refresh

i tried to set up Incremental refresh in desktop for dataset, i get the same 'time out error'....

dont know whats wrong?

Community Support Team
Community Support Team

Re: dataflow refresh failing after setting up Incremental refresh

hi, @reddy_powerbi 

If you could refer to this post to check it in power bi desktop:

https://community.powerbi.com/t5/Service/MS-SQL-server-timeout/td-p/375307

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: dataflow refresh failing after setting up Incremental refresh

@v-lili6-msft     the refresh works fine without Incremental Refresh set up ..te timeout issue occurs only the Incremental Refresh is set up bot on  datasets and datalows

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 108 members 1,609 guests
Please welcome our newest community members: