Forum Discussion

ontario234's avatar
ontario234
Icon for Helper I rankHelper I
9 years ago

Import data from access database that uses ODBC connection

Hi,   I have access database that uses ODBC connection to extract data which is stored in the SQL server. I installed power BI desktop and need to import data from this access database. How can i a...
ontario234's avatar
ontario234
Icon for Helper I rankHelper I
9 years ago

Below is the error i am getiing when i try to load data from access database(mentioned in the post above) in power BI

 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'Sql Server' failed.
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=access2
    OdbcErrors=Table

ahenriques's avatar
ahenriques
New Member
8 years ago

I am having a very similar problem...has this issue been solved?

 

Many thanks