Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Pull Data from many different tables in access database

Hello everyone,


I have a project and I'm in trouble. I had been believing I find a solution but can't. Briefly, I have a access database that includes information data of  some different kinds consume materials. But this data in different tables and all tables same formatted. I want to pull all data from the tables in database. Is there a way to do this?


I attached screenshot of tables,



Community Support
Community Support

Hi @bluefalcon ,


Are you trying to connect Accsee to Power BI?

Power Query Access database connector - Power Query | Microsoft Learn


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Frequent Visitor

Is not there any ideas for this topic? Only a idea for open my solution road....

Super User
Super User

It's lacking detail.

What is the problem? Have you imported the data into powerbi? How far did you get?

What is the desired result?

Is it very hard issue?

Okey, here are the details of my problem,

I know pull data from many sources including access databases . But my problem is I don't know to pull data from all different tables in same database to PBI Desktop. If I pull all tables data i will create a consumption dashboard for periodicly. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors