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
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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