Forum Discussion

ontario234's avatar
ontario234
Icon for Helper I rankHelper I
9 years ago
Solved

Import Data from Access that uses ODBC connection

Hi,   I have MS access database that extracts data from SQL server using ODBC connection. I need to import this database in Power BI desktop. How can i achieve this? I DO NOT want to directly query...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi ontario234,

     

    In Power BI desktop, to get data from Access database, you can use Access Database data source below:

     

     

    As this connector use Access Database Engine, you need to install Access Database Engine version, either 32-bit or 64-bit, that matches your Power BI Desktop version. See: Resolve issues importing Access and .XLS files in Power BI Desktop.

     

    By the way, use SQL Server database in Power BI desktop, we can also specify the T-SQL query.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi ontario234,

 

In Power BI desktop, to get data from Access database, you can use Access Database data source below:

 

 

As this connector use Access Database Engine, you need to install Access Database Engine version, either 32-bit or 64-bit, that matches your Power BI Desktop version. See: Resolve issues importing Access and .XLS files in Power BI Desktop.

 

By the way, use SQL Server database in Power BI desktop, we can also specify the T-SQL query.

 

 

Best Regards,
Qiuyun Yu

JWBennett's avatar
JWBennett
Regular Visitor
8 years ago

MS Access data sources do not currently have a supported data gateway allowing scheduled refresh.  However, ODBC does.  If there is a back door to using the ODBC data source with MS Access I would like to know about it.