Forum Discussion
External component as thrown an exception
I hope this isn't a double-post. My last reply errored-out, and I don't see it in this thread. So I'm trying again.
I have begun seeing this problem just this week. I am using a remote Win 10 VMWare machine via RDP at a client's site. The PBI Desktop file has worked fine for a few months. It connects to a single query in a very small Access.accdb file (492K).
This morning I updated to the Feb 2020 release and had the same problem.
I have been trying to convince the client that PBI would be better than the Excel solution I started them off with. They are interested and want me to build it out with some more features before showng the President. This problem puts all of us developers in a bad position. I have another client that is chomping at the bit to use this stuff internally AND for THEIR clients! Right now, I would have to tell them to stand by.
I hope MS will escalate this and get a solution fast.
The technician led and encouraged me to use the OBCD driver. As you go thru the steps, you will be prompted for excel or access. For my simple test, that solution seemed to work.
Part of my challenge, I'm connecting thru a folder, with multiple access files. This OBDC solution is good for a single file/query. I've got 10-15 files, and not excited about a short term surgery, not knowing if a fix is quick to come or months...
The technician was to get back to me once they got past the investigation stage.
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?
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.
Any luck with the Experts?