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 have been able to do for MS Access databases.  However, I'm receiving the error below:

 

PlexConnectionError.PNG

 

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:

 

PlexConnectionError2.PNG

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

Need Help

9 Replies

  • 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