Can I use an sql query to import from access database

elz

---

I would like to use sql query to select the fields from an access database table to import into power bi desktop.
I currently have the sql queries in a text file.

---

You should be able to use sql query to import access database into Power BI desktop by using the ODBC import option.

---

I tried using the ODBC import option.

I selected MS Access Database as the DSN and pasted the sql query into the last box.

The connection string field is optional, so I left it blank, but realized that my sql statement doesn't point to the database.
That is where my problem is. Where/how do I point to the database for the sql statement to point to?

---

In order to do this, you need to create a DSN for ODBC first. Please refer to How to: Set Up an ODBC Data Source for the detail steps to create a DSN.

After creating the DSN, then you can go to Power BI desktop, select ODBC import option, choose the DSN you created and put your sql query into SQL Statement, and click OK.

Then click Connect.

Last, click load to finish the data import.

Regards