Forum Discussion

tronning's avatar
tronning
Regular Visitor
7 years ago

Connecting PowerBi to MS Access

I want to connect the tables in the data set in powerBi to Access.  

 

 

 

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi tronning ,

    Do you want to connect the data source from Microsoft Access to Power BI?

    If it is, you could use the connector Access Database in Power BI Desktop.

    Get Data>> More>> Database>>Access Database

    If you still need help, feel free to ask.

    Best  Regards,

    Cherry

     

    • tronning's avatar
      tronning
      Regular Visitor
      7 years ago

      I am trying to go the opposite direction.  PowerBI -> Access    

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi tronning ,

        If I understand your requirement correctly that you want to connect power bi in Access Database?

        By my tests, there is no direct connector to get data from power bi in Access Database.

        You should have a consult of Access Database support to get the most professional help.

        You may export data in Power BI to excel and then get data from in Excel as a workaround.

        Best Regards,

        Cherry