Forum Discussion
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. '
4 Replies
- AnonymousNot applicable
i tried to set up Incremental refresh in desktop for dataset, i get the same 'time out error'....
dont know whats wrong?
- v-lili6-msftCommunity Support
hi, Anonymous
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
- AnonymousNot applicable
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
- jochungJEFrequent Visitor
Anonymous I have the exact same issue. Do you have a solution yet?