Pull Data from many different tables in access database

[bluefalcon]

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,

[v-jayw-msft]

Hi @bluefalcon ,

Are you trying to connect Accsee to Power BI?

Power Query Access database connector - Power Query | Microsoft Learn

[bluefalcon]

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

[HotChilli]

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?

[bluefalcon]

Is it very hard issue?

[bluefalcon]

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.