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

Yes. I don't have SQL server on my computer. I use access to extract data from SQL server database and my access in well established with number of queries that i use everyday. This is the reason i need to import access database in power BI so i could use the already built queries to create graphs and all sorts of other analysis. Thx

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