Forum Discussion

GS-OIT's avatar
GS-OIT
Helper I
7 years ago

Dataflows not refreshing

I have a few dataflows set up which use API sources via Basic Auth. They were working fine 2 days ago but stopped this morning. I have checked and they load correctly in the query editor (in dataflows) and call the API but if I refresh them via the menu or schedule they simply do not start. I have downloaded the errors and it just says all entities failed to refresh.

 

Error: Internal error Request ID: 4ffed8b7-9429-cbd4-8056-b24b5852bcef Activity ID: 312445a0-1b37-4414-8210-3e9868b5686f

 

UPDATE: I have now added a flow which uses just an Azure SQL Table with the same result (can see the data in the editor but does not refresh on-demand or scheduled:

 

Error: Internal error Request ID: a924e5c9-2910-0f2c-fe7b-2d6af9f77596 Activity ID: 7a5c5f49-77ea-4e66-8953-298cc1af96fe

19 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi GS-OIT,

     

    Can you share the complete error message, please? I tried to find it in the log database and I did find something. It seems you need to use a new authentication method. I would suggest you contact your administrator.

    >>>AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access 'f3b07414-****************41f3f4128'.

     

    Best Regards,
    Dale

    • GS-OIT's avatar
      GS-OIT
      Helper I

      The API based issues have the following error output.  I have the same code running successfully within a PBI dataset on the same group.

       

      Run Time: Invalid date

      Dataflow: ####### - Lookup Tables

      Status: Failed

      Entity: Boards

      Start: 30/11/2018 17:05

      End: 30/11/2018 17:05

      Failed Error: Internal error Request ID: fc4ee9e1-0593-e23d-1f65-19117de875f6

      Activity ID: f6056529-bf86-4f11-ba28-88a01d419e2e

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi GS-OIT,

         

        Please check the settings of the Dataflow. What I can find is the credential error. 

        Dataflows-not-refreshing1

         

        Best Regards,
        Dale