Dataflows started failing

[freder1ck]

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 time	Dataflow name	Dataflow refresh status	Entity name	Start time	End time	Entity refresh status	Error
3/2/2019 9:47	Kansas City Area Zip Codes	Failed	Jackson County Zip Codes	3/2/2019 9:47	3/2/2019 9:47	Failed	Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: e31201cf-d364-41e1-aaac-fad20c599470
3/2/2019 9:47	Kansas City Area Zip Codes	Failed	Platte County Zip Codes	3/2/2019 9:47	3/2/2019 9:47	Failed	Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 78367d63-65cc-4f10-8511-01d0cc3a178e
3/2/2019 9:47	Kansas City Area Zip Codes	Failed	Clay County Zip Codes	3/2/2019 9:47	3/2/2019 9:47	Failed	Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 87fe6317-f488-4b55-88a7-7e3aadb0d016
3/2/2019 9:47	Kansas City Area Zip Codes	Failed	Wyandotte County Zip Codes	3/2/2019 9:47	3/2/2019 9:47	Failed	Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 02db6b05-9375-40d7-b67b-f18e77d81862
3/2/2019 9:47	Kansas City Area Zip Codes	Failed	Johnson County Zip Codes	3/2/2019 9:47	3/2/2019 9:47	Failed	Error: Internal error Request ID: 07ee5535-9b40-175b-f1bb-e0351ee08a18 Activity ID: 6a3bc987-52c1-4fac-8d2d-b2e166bd8fa9

[v-yuezhe-msft]

@freder1ck,

Glad to hear the issue is solved.

Reagrds,
Lydia

[freder1ck · Accepted solution]

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]

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

[freder1ck]

Configuring an Enterprise Gateway for use with dataflows
To use an on-premises data source in a dataflow, any user creating the dataflow must have an Enterprise Gateway installed and configured. The user creating the dataflow also must be the Enterprise Gateway's administrator in order to use that gateway for a dataflow.
https://docs.microsoft.com/mt-mt/power-bi/service-dataflows-on-premises-gateways

[jcarville]

@freder1ckthanks for the extra bit of clarity, I am the administrator for the gateways that were failing.

In the end my solution turned out to be turning Multi Factor Authentication off for a day and then putting it back on again (the classic off/on approach) as outlined here: https://community.powerbi.com/t5/Community-Blog/Why-is-my-Power-BI-dataflow-refresh-failing/ba-p/623...