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
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

       

      • igavio's avatar
        igavio
        New Member
        1 year ago

        tronning (and me) is asking:

        I have some table data STORED inside Power BI.

        Can I create a linked table in MS Access that has as its source the data in Power BI?