Refresh Error / Failure

[Bgladding]

For the last week or so, I have random refresh errors - usually something along the lines of "Unknown Exception".   Similar issue refreshing in service or refreshing on desktop.  have uninstalled / re-installed gateway and pbi desktop.  no difference.  This is new behaviour and no structural changes have been made to the data source (MS Access file).  The issue is randomly consistent - that is, it may occur once, then another attempted refresh will work (or won't work).    The most recent error is (from pbi desktop):

Feedback Type:
Frown (Error)

Timestamp:
2020-01-28T03:21:32.4575676Z

Local Time:
2020-01-27T19:21:32.4575676-08:00

Session ID:
b082e34e-159d-4a17-a1c9-188a9a0deb91

Release:
December 2019

Product Version:
2.76.5678.782 (19.12) (x64)

Stack Trace:

Server stack trace:

Exception rethrown at [0]:
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)

Exception rethrown at [1]:
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Mashup.OleDbProvider.MashupRowset.get__Rowset()
   at Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)
   at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
38.9 GB

Private Memory:
879 MB

Peak Working Set:
1.02 GB

IE Version:
11.592.18362.0

User ID:
d1d0623d-b0a1-431f-b15a-ef5ff7ee3842

Workbook Package Info:
1* - en-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\*****\Microsoft\Power BI Desktop Store App\FrownSnapShot1115689995.zip

Model Default Mode:
Import

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_QueryDiagnostics
PBI_themeDialog

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-yuta-msft]

@Bgladding ,

Check if the credentails are valid and if there's some permissions like "read" are not allowed on MS access side. You can also doc below to troubleshoot this issue.

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

Regards,

Jimmy Tao

[Bgladding]

@v-yuta-msft 

Thank you for your reply - credentials are fine.  I am the sharepoint owner (where the data is stored), the creator of the Access database, the owner of the Workspace, and the creator of the pbi report.

The link that you provided does not seem to address the issues that I'm having.

The issue is random - it will fail sometimes, and then be fine.  Scheduled refresh will work one time and then not work the next.  Manual refresh will not work then will work.  This happens in both the Desktop pbix file and in the pbi service.

Nothing has changed in the data source (aside from daily incremental updated information).

Noting has changed in the gateway (aside from an updated gateway service).

The attached show the most recent error in the service as well as a sampling of the recent update history.  Note in the history that refreshes that fail or succeed are both scheduled and on demand.

This issue is also not limited to one data source and one workspace.  I am having the same issue with three different data sources in three different workspaces.

Any further insights are appreciated.

thanks,

b

[Bgladding]

@v-yuta-msft 

I should also have mentioned - look at the refresh history for 23 Janaury.  Note that the on demand refresh failed at 7:59, then 8:01, then worked at 8:05.

Again, no changes to the data source or pbi reports.  Just repeated attempts to refresh.  

thanks,

b

[Bgladding]

@v-yuta-msft 

Here is a refresh history for this evening.  Basically a series of fails followed by a completion.  No changes in the data source, the gateway, permissions, etc.