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...
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

ontario234 so are you saying you are pulling from a sql database through access to power bi?

 

your image is broken

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