Forum Discussion

bluefalcon's avatar
bluefalcon
Frequent Visitor
3 years ago

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,

 

Need Help

5 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      bluefalcon
      Frequent Visitor
      3 years ago

      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. 

  • bluefalcon's avatar
    bluefalcon
    Frequent Visitor
    3 years ago

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