Forum Discussion

RMartinoBoston's avatar
RMartinoBoston
Regular Visitor
9 years ago

SAS ODBC

SAS ODBC drivers (9.44 or 9.43) to connect to SAS files from the Power BI Desktop (all 64 bit on 64 bit Windows 10) are generating the following error message: "ODBC: an error occurred but no ODBC er...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi RMartinoBoston,


If you want to know how to use odbc to connect, you can take a look at the below link:

 

Odbc.Query([Driver=Provider, Server=ServerName, Database=SourceName], Querystring)

      

Odbc.Query

 

 

Odbc.Query("Driver={SQL Anywhere 16};Host=montegoref7",  "select * from Products")  
  
Odbc.Query([Driver="PostgreSQL Unicode", Server="montegoref7", Database="Northwind"], "select * from ""public"".""Products""")

 

 

Notice, you should ensure the provider is correctly installed in your computer.

 

Regards,

Xiaoxin Sheng

RMartinoBoston's avatar
RMartinoBoston
Regular Visitor
9 years ago

Thank you Xiaoxin Sheng,

 

However, without a Server to refrerence, I don't seem to be able to get the ODBC query to work.

 

Rachael

  • Grusque's avatar
    Grusque
    New Member
    7 years ago

    Hi All,

     

    Generally not great documentation on this driver, seems everyone else knows how to do it.

     

    Use the SAS Local Data Provider which you can find in:

    Data->From Other Source->From Data Connection Wizard->Other/Advanced->SAS Local Data Provider <<latest version on your machine>>

     

    Enter only the path into Data Source:, nothing else, test the connection and it should bring up the tables in that location.