Forum Discussion

Dellis81's avatar
Dellis81
Post 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
dax's avatar
dax
Community Support
6 years ago

Hi Dellis81 ,

This might be related to the large data, you could refer to this post  for details. You said it also seems to be related to the data type, so you could try to import this data into other datasource , then you connect ti it to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Dellis81's avatar
    Dellis81
    Post Prodigy
    6 years ago

    Thank you Zho

     

    The error I initially reported takes place when I step thru various queries.   I have since isolated the problem (I think) to connections to Access databases (mdb).

     

    Basically - I created a whole new pbix file, with only the initial data ACCESS importing queries.   I am finding now, the refresh from the PowerBI ribbon works properly the first time, but second and consecutive attemps I get this error.

     

     

     

     

     

     

     

     

     

    I also find it interesting, during the refresh process, the import status is provided.  First - those with TAD are showing as pulled from a local directory "C drive" and in rows.   Versus the CAD import, only shows the GB being pulled in.

     

     

     

     

     

     

     

    But, as you can see below, file a lcoations are in same directory - relatevely small in size, with the CAD no where close to GB magnitude.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    I greatly appreciate anyone's guidance -as this is a real hinderance to my progress.

    thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I'm facing the same error since a week (in files and models that used to work perfect!). Ones I get are along similar lines with no error description available (often with code: E_UNEXPECTED(0x8000FFFF). 

      Anyone with a solution yet?

      • Dellis81's avatar
        Dellis81
        Post Prodigy
        6 years ago

        I was in contact with Microsoft support yesterday (Monday Feb 10th), technician was very diligent and understood the problem.  I have not had any followup today.   As I know, I will respond back to this thread.