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

      • 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