Forum Discussion

freder1ck's avatar
freder1ck
Kudo Kingpin
7 years ago
Solved

Dataflows started failing

My dataflows worked, but then started failing. Every dataflow has a valid gateway. Gateway is online, and all queries load into the editor. Each dataflow has one source and I'm not combining dataflows. Some dataflows connect to Azure SQL, others to anonymous web content.

 

Here are some error logs, thanks!

 

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
3/2/2019 9:47Kansas City Area Zip CodesFailedJackson County Zip Codes3/2/2019 9:473/2/2019 9:47FailedError: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: e31201cf-d364-41e1-aaac-fad20c599470
3/2/2019 9:47Kansas City Area Zip CodesFailedPlatte County Zip Codes3/2/2019 9:473/2/2019 9:47FailedError: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 78367d63-65cc-4f10-8511-01d0cc3a178e
3/2/2019 9:47Kansas City Area Zip CodesFailedClay County Zip Codes3/2/2019 9:473/2/2019 9:47FailedError: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 87fe6317-f488-4b55-88a7-7e3aadb0d016
3/2/2019 9:47Kansas City Area Zip CodesFailedWyandotte County Zip Codes3/2/2019 9:473/2/2019 9:47FailedError: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 02db6b05-9375-40d7-b67b-f18e77d81862
3/2/2019 9:47Kansas City Area Zip CodesFailedJohnson County Zip Codes3/2/2019 9:473/2/2019 9:47Failed

Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 6a3bc987-52c1-4fac-8d2d-b2e166bd8fa9

Gateways
  • freder1ck's avatar
    freder1ck
    7 years ago

    RESOLVED: "The user creating the dataflow also must be the Enterprise Gateway's administrator in order to use that gateway for a dataflow." I changed the admin. 

5 Replies

  • freder1ck's avatar
    freder1ck
    Kudo Kingpin
    7 years ago

    RESOLVED: "The user creating the dataflow also must be the Enterprise Gateway's administrator in order to use that gateway for a dataflow." I changed the admin. 

    • jcarville's avatar
      jcarville
      Skilled Sharer
      7 years ago

      Hi freder1ck , I've been having a similar issue myself. Can you provide me with a bit more detail about what you mean by Enterprise Gateway administrator? Are you referring to the gateway within the PBI Service or is this a setting in Office 365?

       

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    freder1ck,

    Glad to hear the issue is solved.

    Reagrds,
    Lydia