cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Dataflow Refresh Error

Has anyone had an issue refreshing any of their dataflows today? I have even tried creating a test dataflow that just pulls in one excel sheet and the dataflow will not refresh. It errors out after 2 hours due to the timeout error.

 

Normally, I have about 10 dataflows that have been working perfectly since I created them.

 

If anyone has had this issue before any help is appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Dataflow Refresh Error

It seems this issue is now resolved  - no word from Microsoft but something must have changed on their end.

View solution in original post

10 REPLIES 10
Highlighted
Frequent Visitor

. Re: Dataflow Refresh Error

My dataflows that pull directly from SharePoint Folders are all taking forever to refresh, and in many cases timing out. My dataflows that use my data gateway are fine. My datasets that pull directly from SharePoint Folders (no dataflow involved) are fine.

Highlighted
Advocate I
Advocate I

Re: . Re: Dataflow Refresh Error

I wonder if it is something on Microsoft's side - I didn't see anything on their status page.

Highlighted
Regular Visitor

Re: . Re: Dataflow Refresh Error

Same here. Dataflows from Sahrepoint not working :S

Highlighted
Post Partisan
Post Partisan

Re: Dataflow Refresh Error

Same here. 

 

All of my Dataflows are timing out today (mine pull from Azure SQL Server).  Running identical queries to Azure SQL Server is fine - it's just the Dataflows .

I tried recreating a new simple one that should take ~1 minute - at minute 45 it's still going, and I assume will time out as well. 

 

 

Highlighted
New Member

Re: Dataflow Refresh Error

We've had exactly the same issue, everything working perfectly over the weekend, but all refreshes today either fail or time out.  All excel files hosted on sharepoint/one drive are failing.  

 

Could do with knowing if this is an ongoing issue before I move all the files off sharepoint and update all the dataflows

Highlighted
Regular Visitor

Re: Dataflow Refresh Error

Exact same issue here. Datflows are failing to refresh with "Internal Error"

Highlighted
Frequent Visitor

Re: Dataflow Refresh Error

Quick Update: I've reported the issue throught their Service Health utility wihtin O365 Admin. If nothing shows up soon, I'll create a support ticket.

 

Same issue here; all my scheduled refreshes for my dataflows are failing one by one with the error that:

 

"us.prod.powerquery.microsoft.com took to long to respond"

 

nslookup reveals this:

Non-authoritative answer:
Name: powerquery-prod.westus.cloudapp.azure.com
Address: 40.82.253.77
Aliases: us.prod.powerquery.microsoft.com
us.prod.powerquery.trafficmanager.net

 

Not sure if this helps but it won't hurt either (for those on MS side hopefully troubleshooting it) 😉   

 

Paul

 

Highlighted
Frequent Visitor

Re: Dataflow Refresh Error

It seems the issue has been resolved; I wish that they would acknowledge the issue though as that makes it a lot easier to explain internally to management.

Highlighted
Frequent Visitor

Re: . Re: Dataflow Refresh Error

Mine are all good now, too.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Users online (808)