Forum Discussion

robarivas's avatar
robarivas
Post Patron
6 years ago

Initial Incremental Refresh Fail

Set up my first Incremental Refresh. It ran for 8 hours on the Service and then failed with the following error message:   {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

robarivas Did you find a solution for this? I'm facing the same issue

robarivas's avatar
robarivas
Post Patron
6 years ago

Hello Anonymous I am still working with Microsoft on a ticket for this. However, I tried changing the (SQL) server name in the M query on the dektop file (pbix) from uppercase to lowercase to match how I have that SQL server connection setup on the gateway and I also, for now, removed joins/merges to some dataflows. One of these changes seems to have allowed the report to successfully execute incremental refresh. Either one is ridiculous in my opinion. If/when I can confirm which (if either) was the resolution I'll post another response.

  • setis's avatar
    setis
    Post Partisan
    6 years ago

    robarivas ,

     

    I was wondering if you managed to resolve this already. 

     

    I have the same error with several reports. Some of them with incremental refresh and others without. 

     

    The reports are refreshed without errors in desktop but I'm getting the same error as you do in the service. 

     

    Thanks in advance.