Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

connecting power bi desktop to ms access query

I have access file and i can connect it with power bi desktop but i want to run on it a complicate query can it be done in power BI

like I think it can be done in power query?

Community Support
Community Support

Hi @Koby 

It seems impossible,  M accessing data function, 

Access.Database(database as binary, optional options as nullable record) as table 

it has no options about query.

Compared to the Sql.Databese()



So, I think it is impossible to do that. But you can get table from ms access and transform to what you want.


Best Regards

Community Support Team _ chenwu zhu


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Super User
Super User

@Koby , it can be done in power query if that is supported in the initial connection. Which I doubt.

You can open a power query can try to replace the table name with a query in parenthesis. I tried that in past for some other database and it did not work.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors