Connecting to a Plex Database from Power Pivot in MS Excel

[jadams0304]

Hello,

Connecting to Plex or even using the tables is completely new to me.  I'm a SQL novice, but pick up on things quickly. 

I'm trying to connect Power Pivot in MS Excel to Plex like I have been able to do for MS Access databases.  However, I'm receiving the error below:

I'm able to actually connect to Plex, because you can see above that I'm pulling in what looks like 6,397 tables.  The problem is that I'm not getting any columns.  There should be a preview of the table where the error message is showing.  Below is the Advanced Editor statement and what I see in the Query editor:

Any help would be greatly appreciated even if it is just assumptions or guesses that might lead me in the correct direction.

My understanding is that nobody else is using MS PowerPivot or MS PowerQuery to connect to Plex.

Thanks,

James

[v-huizhn-msft]

Hi @jadams0304,

I can't open your pictures, so I don't see the error message. You import the data from Plex Database from Other Sources, and connect to Plex Database, right?



PowerPivot for Excel can import data from a wide variety of sources. This article explains the kinds of data sources you can use. Please check it, the error maybe caused by your unsupported database.

Best Regards,
Angelia

[jadams0304]

Thanks for your reply Angelia.  I'm using the ODBC connection option.  I downloaded the ODBC driver from Plex our ERP provider.  I'm using their 64-bit driver, because I have 64-bit Windows and 64-bit MS Office.  Below are the pictures:

[v-huizhn-msft]

Hi @jadams0304,

Please check your 64 version driver's path, if it is located in the %systemdrive%\Windows\SysWoW64 folder. Please it is, please put it in this path.

Best Regards,
Angelia

[jadams0304]

Angelia,

I uninstalled the driver and re-installed it in the directory you specified, but I'm still receiving the same error message.  Any other ideas?

Thanks,

James

[v-huizhn-msft]

Hi @jadams0304,

It's werid, it may be caused by driver. I will post the update if I have new idea.

Thanks,
Angelia

[jadams0304]

Hi @v-huizhn-msft,

Please see the email below that I recently sent Plex:

[Jesse2Caldwell]

Hello I’ve been Able to connect Plex ERP with both Excel and Power BI

I am very new the the forum here and don’t know how to direct message you - but if you would like to connect so we can discuss the steps I’ve taken I would be more then happy thanks very much and have a great Evening

Jesse Caldwell

[Jmarchan]

Hi Jesse
I new here but I am very interested to see how the connection is made between Power BI and PLEX ERP.

how can I send you a private message with my email address?

Thank you

Javier

[jadams0304]

Hello Angelia, thanks for helping me work through this.

Below is where the driver is installed:

C:\Program Files\Plex\PlexReportDataSource

Should I reinstalled it in this location?

%systemdrive%\Windows\SysWoW64

Is it possible for me to just cut or copy the folder on the C: drive and paste it into the "SysWoW64" folder?

Thanks,

James