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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors