Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
6 years ago

External component as thrown an exception

Hello - Since Wed Feb 5th, I have really been challenged with multitude of refresh errors.  Primarily related to External component has thrown an exception or unknown error.   As I go look at queries...
Need Help
Rich_P's avatar
Rich_P
Icon for Helper II rankHelper II
6 years ago

Thanks for the hint. Did the tech recommend ODBC over OLE DB for any reason? 

 

Am I to understand you are tapping 10-15 databases in a folder? If so, would it help you to build a new database file and link to the pertinent tables in each of the 10-15 files just so you can consolidate them into a single source as far as PBI is concerned?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have a screen share session with an MS support rep, Power BI expert, and Sharepoint expert tomorrow morning.  I get this error when connecting to a Sharepoint folder and pulling tables out of Excel files in those folders and appending those tables together in Power BI.

 

The process has been working for a year and a half and since Feb. 10 or so, I haven't had one successful refresh in Power BI Desktop.  I've got the issue escalated so that they have 3 people connecting with me on one call tomorrow.  Hope to find a solution...

 

Will keep you guys posted.