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.
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.
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
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.
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.