Forum Discussion

swan1099's avatar
swan1099
Helper I
9 years ago

Can PowerBI Web Service Refresh Access 32 Bit database?

Hello,   We are a small company, and our ERP system is powered by MS Access. I host our DB files in our sharepoint environment. I've been able to design & refresh this data with the PowerBI desktop...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

swan1099

 

Access 32 bit database is supported in Power BI. Just make sure you have the 32 bit Microsoft Access Database Engine 2010 on your machine which you create your Power BI report.

 

After you publish your .pbix onto Power BI Service, it will take Personal Gateway by default. I suggest you change it to On-Premise Gateway (create a Web source in On-Premise Gateway) to see if you can edit your credential in data source setting and trigger refresh properly.

 

Regards,

 

  • swan1099's avatar
    swan1099
    Helper I
    9 years ago

    Hello,

     

    When attempting to sign in with a credential, the service will only let me choose from:

    • Anonymous
    • Basic
    • Windows

     

    I've tried all three, and none seem to work -- unfortunately organization account isn't an option?

     

    Any thoughts?

     

    Thanks!