Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
@freder1ck,
Glad to hear the issue is solved.
Reagrds,
Lydia
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.
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
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
@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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.