cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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 6
Microsoft
Microsoft

@ontario234

 

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

 

Capture.PNG

 

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

 

Regards,

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

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

 

your image is broken





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

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

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

 

Many thanks

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors