Connect to two separate access databases

[Anonymous]

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 go about doinbg this through PowerBI?

Thanks

Chris

[prihana]

Connect to both databases seperatley and link them inside Power BI

[Anonymous]

I was wanting to link them under one SQL query, it seems like this is not possible

[v-yuezhe-msft · Accepted solution]

@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