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 er...
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
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.