Forum Discussion

jadams0304's avatar
jadams0304
Frequent Visitor
9 years ago

Connecting to a Plex Database from Power Pivot in MS Excel

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 hav...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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's avatar
jadams0304
Frequent Visitor
9 years ago

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's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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's avatar
      jadams0304
      Frequent Visitor
      9 years ago

      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

       

       

       

       

    • jadams0304's avatar
      jadams0304
      Frequent Visitor
      9 years ago

      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's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi jadams0304,

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

        Thanks,
        Angelia