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

Question

Hello all,&nbsp;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:&nbsp;Unable to connect to the data source undefined.No error message available, result code: E_UNEXPECTED(0x8000FFFF).&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;Any thoughts would be appreciated. Thanks!

v-lid-msft · Answer

Hi&nbsp;StephenK&nbsp;,
&nbsp;
Does this dataset&nbsp; connect to a XLSB file? Please refer to this similar thread:&nbsp;https://community.powerbi.com/t5/Desktop/No-error-message-available-result-code-E-UNEXPECTED-0x8000FFFF/m-p/923719
&nbsp;
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:&nbsp;https://docs.microsoft.com/en-us/powerquery-m/table-selectrowswitherrors&nbsp;&nbsp;
Best regards,
&nbsp;

stephenk · Answer

v-lid-msft&nbsp;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.

v-lid-msft · Answer

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

Best regards,

Forum Discussion

Related content

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

Unusual error when accessing an Access database...E_UNEXPECTED(0x8000FFFF

ParaTimeLine not available

Schedule refresh

Scheduled pipelines failing