cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
swan1099 Regular Visitor
Regular Visitor

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 editor, but when I upload the file into the cloud service, the refreshes all seem to fail. Is the service capable of refreshing 32bit Access?

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Can PowerBI Web Service Refresh Access 32 Bit database?

@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 Regular Visitor
Regular Visitor

Re: Can PowerBI Web Service Refresh Access 32 Bit database?

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!