Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
masplin
Impactful Individual
Impactful Individual

Cancellation occurred when sending or receiving all files. Serious problems

I have 4 models on schedule refresh. Last one updated successfully at 10am but since then all models are immediately showing this error. i have treid restarting the gateway, which shows online, but no joy. I have not touched the models, but they wil lhave picked up new data during the day.  I have tried to refresh the pbix file and cannot get them to  refesh as just churning the data without finishing.  These would normally complete in about 20 mins.  I'm concenred some bad data has got into the model, but dont know if this would cause this error message (which pops upin 5 seconds)

 

Any clues appreciated as al lthe company reporting and CRM is now dead in the water

 

Mike

 

Power BI

Last refresh failed: Tue Jul 17 2018 19:23:20 GMT+0100 (GMT Summer Time)
Cancellation occurred when sending or receiving a request.
Hide details
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:4e859633-842b-0517-1568-617ea8849bf0
Request ID:819d9cb4-5c35-61f3-085b-9cc2f093aba3
Time:2018-07-17 18:23:20Z
2 REPLIES 2
naidoode
Frequent Visitor

I had a similar issue. It occurred when a bad date got into the dataset. Run the query against your DB and find and fix any bad dates. I simply just put in a "where AuditDate >= DATEADD(year,-1,GETDATE())" clause to only select valid dates and it worked like a charm.

masplin
Impactful Individual
Impactful Individual

Sadly I dont think that is the issue.  i opened the pbix file and refreshed each table one by one and all worked fine. i then republished and was fine. Then the next scheduled refresh failed again?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors