I have a data source for which I use OLE DB to connect to a VFP database, I use Power BI 32 bit and it works perfect
I published it in the power bi service and installed a gateway but when I try to connect I get an error. First I tried the standard gateway, and now I have the personal gateway
in the personal gateway when editing the credentials it gives this error
MSG DE ERROR:
Could not update data source credentials: An error occurred while reading data from the provider: 'The provider 'vfpoledb' is not registered on the local computer.'
The gateway works fine, since it connects without problem to another data source in Excel, but for the data source in VFP with the OLE DB it gives this error.
I already registered the vfpoledb.dll file with the Regsvr32 command
My windows is 10, 64 bit. The OLE DB source is 32-bit, as I mentioned before I use it with 32-bit Power BI just in this case that I have to access this old DB in VFP, the local update works well for me, but I need to automate the updates
regards
Widen