Pervasive SQL

[Yggdrasill]

I'm trying to connect to a db. I'm getting the name of the db but no tables.

This is what I've done so far

1. Installed Pervasive ODBC Client Interface drive
    
2. Setup System DNS in ODBC Data Source Administrator (32-bit) like following (Test works)
   
3. In Get Data I chose ODBC and ICESF as DSN
   
4. Navigator shows the following
   
   All the db are empty except for one dummy db.

Now for authenticating I've tried

1. Windows auth - which works. My windows account is in the admin group on the server
2. Database - my user/pass works with the same result as above

On the server side I've created an Engine DSN like in these Instructions 

• 64bit OS, with 32-ODBC Engine interface

Has anyone here successfully pulled out data from Pervasive SQL v.13 with Power Query in Power BI Desktop ?

Please, share

[dax]

Hi Yggdrasill,

Accorin to your description, it seems that you could connect to Pervasive SQL successfully, but you can't get the table from database, right? And it seems that when you use windows credential , it could work, right?

You need to make sure the user(which use database credential) have permission to these table. In addition, if you write the SQL query in advanced option, will you get table data?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.