Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Connect to two separate access databases

Hi,   I am wanting to connect to two different access databases in one SQL Statement.   Would you connect to one then reference the other and would that also use the same connector? How would I ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Using the built-in Access connector in Power BI Desktop, it is not possible to write SQL statement to connect to Access databases. You would need to connect to one Access database firstly, and connect to another database again.

    To work around this issue, you can create an ODBC data source for your Access database, then use ODBC connector in Power BI Desktop to connect to the source and write specific statement to get data, there is a similar thread for your reference.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Using the built-in Access connector in Power BI Desktop, it is not possible to write SQL statement to connect to Access databases. You would need to connect to one Access database firstly, and connect to another database again.

To work around this issue, you can create an ODBC data source for your Access database, then use ODBC connector in Power BI Desktop to connect to the source and write specific statement to get data, there is a similar thread for your reference.

Regards,
Lydia