Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
swan1099
Helper I
Helper I

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
v-sihou-msft
Microsoft Employee
Microsoft Employee

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

 

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!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!