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 achieve this? I was able to connect to SQL server directly using "ODBC" as data source however I DO NOT want to connect to SQL server directly. I need to extract the same data from access database since my access database is well establised and contains 100s of queries that I use everyday. Please help.

 

Thanks

6 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    ontario234

     

    You just need to create a DSN opening connection to Access Database with Access Driver.

     

     

    Then get data from ODBC in Power BI Desktop and select that created DSN.

     

    Regards,

    • ontario234's avatar
      ontario234
      Icon for Helper I rankHelper I
      9 years ago
      Hello again,

      I was able to create the system DSN (the one that you indicated) however, it did not solve my issue. The access database that i need to import in power BI is itself extracting the data from SQL server via ODBC connection. The following is the error i am getting when i try to load the data from my access database in power BI desktop. Help please..Thanks in advance
      Inline image 1

      • 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