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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Power BI "External Component has thrown an exception"

Hello,

 

I've been receiving an error message saying "External Component has thrown an exception" this entire week for refreshing a report that has been refreshing successfully this entire year until now.  This message does not consistently appear on one table in my refresh.  It has appeard on different tables during different refreshes.

 

I am consolidating multiple spreadsheets from a Sharepoint folder to create tables in this dataset.  The error message asked me to post details here and perhaps someone can assist me.  The error message details are:

 

 

 

Feedback Type:
Frown (Error)

Timestamp:
2020-02-13T22:18:10.5720941Z

Local Time:
2020-02-13T16:18:10.5720941-06:00

Session ID:
516720a1-7380-43fa-a51c-ab82a4e0370f

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.17763.0 (x64 en-GB)

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

Peak Virtual Memory:
42.5 GB

Private Memory:
1.61 GB

Peak Working Set:
2.09 GB

IE Version:
11.864.17763.0

User ID:
54b02672-a026-4f07-8f6f-22c7dc0d0417

Workbook Package Info:
1* - en-US, Query Groups: 20, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\p-aman.gheewalla\Microsoft\Power BI Desktop Store App\FrownSnapShot126733705.zip

Model Default Mode:
Import

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_QueryDiagnostics
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree
PBI_themeDialog

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
v-yuta-msft
Community Support

@Anonymous ,

 

Have you changed/modified any value or data type on sharepoint side? If this issue couldn't be solved or is very urgent, I would suggest you create a support ticket here.

Support Ticket.gif 

Regards,

Jimmy Tao