cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Help! - Use Access database connector and custom SQL

Hi,

 

I am trying to use the Power Bi access database connector however when it loads up it asks for which tables i want to select.

 

I am wanting instead to use custom SQL.  Is this acheivable using the connector?

 

Thanks

 

Chris

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Help! - Use Access database connector and custom SQL

Hi jak82,

 

Are you trying to connect to MS access database in power bi desktop? Power bi can connect to MS access database directly without any customer connector(But you need to install Access database engine first). Click Get Data->Database->Access database. 

 

In addtion, what does custom SQL mean? Does it mean the SQL statement and you want to connect to MS access database using SQL statement? You can use ODBC connection instead of connect to MS access database directly. For details, please refer to this case: https://community.powerbi.com/t5/Desktop/Can-I-use-an-sql-query-to-import-from-access-database/td-p/....

 

Regards,

Jimmy Tao

Highlighted
Anonymous
Not applicable

Re: Help! - Use Access database connector and custom SQL

Hi,

 

Yes for some reason ODBC connection does not allow me use table aliases.  I was wanting to check if the access database connector allowed me to but I am unable to find where I can put in my DQL code rather than select tables.

 

Thanks

 

Chris

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors