Forum Discussion
Refresh Data (Access DB Source) issue
I have been able to use Excel as a datasource (locally or via sharepoint). I just started to try using Acces as a data source instead. I have 32bit applications on my server (Office/PowerBI Desktop). I can get data from Access locally or in sharepoint. I create my report and publish it no problem. But when I go to refresh my dataset I get the message below. I installed the 32bit 2010 Access DB Engine same issue. I went over to another server and installed the 64bit version of PowerBI. This time I instllead the 64bit version of 2010 Access DB Engine. Same issue! Again my Access is an .accdb file created in a 32bit application. I have tried accessing my db local and via sharepoint and get the same result. Any ideas?
Underlying error code: -2147467259
Underlying error message: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read 'msflabor.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.NotFound
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 3f419d59-3dd4-4bec-af21-92fc0df2a197
Request ID: 02f690b3-7936-bb92-3f7f-fcbd17361595
Time: 2020-12-08 22:33:46Z
1 Reply
- v-deddai1-msftCommunity Support
Hi PowerbiJJ ,
Would you please try to update your gateway to the latest version? You can follow the similiar post:
And you can also refer to : https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
If this post help, please consider accept it as the solution to help others find it more quickly.
Best Regard,
Dedmon Dai