cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JpaveyBI
New Member

Report has several Dataflows won’t refresh in service

I have a report that is getting all its data via 31 dataflows (PowerBI in the on-premise gateway) and no other datasources.

 

Refreshes fine in Desktop (about 5-10 minutes) but will not refresh at all when in the service. I keep getting an error that says cannot connect to data source undefined:

 

Underlying error code: -2147467259
Underlying error message: We're sorry, an error occurred during evaluation.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 4051fbee-5a67-4d14-9f61-cd1446cedc8f
Request ID: 14db3f28-09f8-4e15-beef-38c27ae138c4
Time: 2021-09-23 21:38:55Z

 

I'm totally stumped and starting to think converting this report from multiple datasources to all dataflows was a mistake?? Help 😞

3 REPLIES 3
JpaveyBI
New Member

It's not the dataflows that are failing to refresh. They have all been refreshing flawlessly for months now. The problem is that I connected to them in a report to create a data model. The report using the dataflows is what is failing to refesh. There is no download of the error on a BI report - only what I pasted in the original message. 

Creea1
Frequent Visitor

Sorry missinterpreted "Dataflows won’t refresh in service"   

Creea1
Frequent Visitor

When you goto the dataflow list in power bi service, and cick on refresh history for one of the failed dataflows, then download the refesh log, see pic below 

Screenshot 2021-09-24 103313.png 

What is the error that it shows. You may have to find the table with the first error. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors