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
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

      • jadams0304's avatar
        jadams0304
        Frequent Visitor
        9 years ago

        Hi v-huizhn-msft,

         

        Please see the email below that I recently sent Plex: