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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
willpage
Helper II
Helper II

Failed Refreshes Since Friday

I've come into work Monday (NZ Time) with a lot of email notifications for failed dataset and dataflow refreshes. The failues are all related to credentials, e.g:
Data source credentials are missing or invalid. Please update the credentials for <data source>

 

The failure is the same no matter the data source, SQL with SQL auth, SQL with AAD auth, SharePoint, OneDrive etc so this leads me to believe it's the Power BI service with the fault rather than any of these upstream sources.

 

Anyone else had this issue or is this a known fault? The failures seemed to start with the overnight refresh activity Friday night - Saturday morning NZ time (UTC + 12)

 

1 ACCEPTED SOLUTION

The problem seems to be resolved now without me doing anything. Refreshes failed 3 nights in a row but manual refreshes and automatic refreshes that happen during the day are now succeeding.

It wasn't anything local to my environment because of the diversity of the data sources that were failing: Multiple Azure SQL databases in different Azure tenacies with various authentication mechanisms, SharePoint Online/OneDrive using OAuth 2/AAD across various different service principals. None of them using any on-premises data gateways.

 

Anyway, problem solved.

 

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Awesome thanks for letting us know...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @willpage 

 

I had a look and all my refreshes are happening successfully.

 

Could it be that maybe something is wrong with your data sources or something in your network?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

The problem seems to be resolved now without me doing anything. Refreshes failed 3 nights in a row but manual refreshes and automatic refreshes that happen during the day are now succeeding.

It wasn't anything local to my environment because of the diversity of the data sources that were failing: Multiple Azure SQL databases in different Azure tenacies with various authentication mechanisms, SharePoint Online/OneDrive using OAuth 2/AAD across various different service principals. None of them using any on-premises data gateways.

 

Anyway, problem solved.

 

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