Forum Discussion

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

Not applicable

9 years ago

Hi RMartinoBoston,

Can you share some detail information about your issue?

In addition, you can check on your connection string to ensure it has correct format and parameters.

You can also take a look at below link about SAS connection string:

SAS connection strings

Regards,

Xiaoxin Sheng

RMartinoBoston
Regular Visitor
9 years ago
Xiaoxin Sheng,
It looks like the IOMProvider requires a SAS Server (local or remote). I am looking for a way to read the SAS7bdat files w/out having access to a SAS server.

I did get some information from SAS about using the SAS Local Provider and instructions on how to use from the Excel Get Data Data Connection Wizard which works great in Excel.

Unfortunately I wasn't able to make that provider work using ODBC or OLE DB in Power BI. Is there another way to do that?

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