Forum Discussion
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 error information was available." during the setup of the data source (before I get to select a file, but after selecting the ODBC data source).
BTW I have been quite successful using R Script!
5 Replies
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:
Regards,
Xiaoxin Sheng
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
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("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
