Maddy99's avatar
Maddy99
Icon for Resolver II rankResolver II
6 years ago
Status:
New

Dataflow API, Sharepoint and Azure sql runs out of time within 15 min

Our dataflow for differnt customer give an Timeout error back. we all got the error whitin 15 min after the start. the 2 hour limitation can not be reach yet. 

 

We got the same error for the following sources

  • API
  • Azure SQL server
  • Sharepoint

 

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
24-2-2020 14:38WindFailedWind24-2-2020 14:3824-2-2020 14:49FailedError: Refreshing an entity exceeded the 2 hour refresh limit. Request ID: 0cb27a86-8caa-9ca7-e098-f459beb4b715 Activity ID: 563f30d6-67f8-4484-bc9b-42c57d70f204

 

Putting the Power query code into a PBIX file and there we do see a good refesh. 

6 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Same here -- dataflows that were running fine (in less than 30 min) are systematically failing since Feb the 22nd. It appears any one entity that takes more than 10 min to load now leaves the entire process hanging?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi all,

     

    I'm not able to reproduce the issue on my side. Please test again, if the issue occurs, please create a support ticket to get help. 

     

     

    Best Regards,
    Qiuyun Yu

  • Hey everyone,

     

    New day and a fresh new start. since this morning everything works again.

    No further support needed from our side. 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi all, 

     

    Please check if these dataflows reside in a premium capacity. If it is, it's the same issue as this one in Support site. 

     


    Best Regards,
    Qiuyun Yu

  • Hey, 

    The dataflows that we tested are not on premium workspaces.