I won't recommend using 32-bit version for either Power BI or Office.Īlso let us know if you guys are using Office365, since you mentioned MS Office i suspect it is a On-Prem edition.For some people with custom configs or inhereting a network with custom configs you may need to take your install a step further and make sure you are connecting to the right download area for your ASDM. Just to avoid complication in future, if this is a POC level work or Access DB is very small try to switch it to 64-bit version.

Not sure if that helps, but hope it at least gets you pointed in the right direction. If the installed Access Database Engine bit version is different from your Microsoft Office installation's bit version, Office applications will not be able to use the Access Database Engine. See the special note - might be applicable to your situation: The machine that has the Access database needs 64 bit everything (OS, Office, Access Engine and Power BI Desktop), I think. IOW - I know you installed the DB engine on the gateway server, but is that where the data is kept? On the Gateway Server? Or on your users local machine? Or somewhere else? Where does the Access database itself live? Subject: Issue with dataset refresh in Power BI service using enterprise gateway with Microsoft access datasource Let me know if you have been able to get this to work! Or do we need to have both Power BI desktop and MS Office both be 64 bit, and do nothing to the gateway server? Would 64 bit MS Office need to be installed as well? We tried to install AccessDatabaseEngine_X64.exe on our gateway server, and still no luck. Note that this server does not have MS Office. Help!! What do we need to do to get around this error? Reason: DataSource.NotFoundĬluster URI: Īctivity ID: e3a85cdc-b396-e6da-4ada-860d49d475a4 ĭM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 To download the client software, visit the following site.

The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file. Underlying error message: Microsoft Access: The '.12.0' provider is not registered on the local machine. Underlying error code: -2147467259 Table: MRO qryMasterQuery. When she went to schedule the refresh on her dataset, she got the following error message:Ĭannot connect to the mashup data source.

She created the Microsoft access datasource in the gateway. She then wanted to schedule an automatic refresh using our enterprise gateway. She was not able to at first, then she downloaded AccessDatabaseEngine_X64.exe and was able to bring in the Access DB into PBI desktop and create reports. A user wanted to bring in a Microsoft access database into Power BI desktop. We have 64 bit Power BI desktop software and 32 bit MS Office.

Dm network viewer 64 bit