cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StephenK
Resolver I
Resolver I

Scheduled Refresh Failure: No error message available, result code: E_UNEXPECTED(0x8000FFFF)

Hello all,

 

We have been getting barraged with a sudden onslaught of scheduled refresh failures for the past couple weeks. Projects are failing at random and throwing the following error message:

 

Unable to connect to the data source undefined.

No error message available, result code: E_UNEXPECTED(0x8000FFFF).

 

The error message is attributed to a certain dataset, but it is always random as to which one fails. Our datasources are a mix of excel files and access .mdb files. The .mdb files seem to be the culprit.

 

The same error occurs randomly in Power BI Desktop. The only solution there is to close and reopen the project file and then it will work.

 

Sometimes kicking off a manual refresh in the online service will be successful, but often it will just throw the same error message. When the next scheduled refresh hits, sometimes it will be successful. The failures just seem very random.

 

All our reports are set to refresh daily. Most of them are run off the same datasets. They drive multiple dashboards and are published to multiple apps so its really annoying when they start acting up.

 

As far as troubleshooting, we have updated our gateway to the most recent version. I've also removed all the projects and datasets from the online service that were throwing the errors and republished them. This seemed to help a little, but overall the problem is still there.

 

The project files and datasets themselves have not undergone any major changes. These reports have consistently refreshed fine for months. The problems just seemed to start out of the blue.

 

Any thoughts would be appreciated. Thanks!

3 REPLIES 3
v-lid-msft
Community Support
Community Support

Hi @StephenK ,

 

Does this dataset  connect to a XLSB file? Please refer to this similar thread: https://community.powerbi.com/t5/Desktop/No-error-message-available-result-code-E-UNEXPECTED-0x8000F...

 

Could you please try to apply a Table.SelectRowsWithErros to see if there are some error after applying a Type conversion, please refer to this document: https://docs.microsoft.com/en-us/powerquery-m/table-selectrowswitherrors  


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-lid-msft 

We do not have any .XLSB files as datasets. I tested all of the datasets that have been throwing errors with Table.SelectRowsWithErrors and did not get any results.

Hi @StephenK ,

 

Sorry for that,this error about access db seems happened frequently since two weeks ago, but we cannot reproduce this issue here, we suggest  you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

 

Support Ticket .gif


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors