I am getting error in visual studio 2017 while doing process table for excel based files. The .xlsx files are located in shared path. We are using the SSAS cubes.
The same tables are getting refreshed successfully from SQL studio Management. I have installed the 32 bit Microsoft Access database engine 2010. I tried with 64 bit Microsoft Access database engine 2010 but its not working.
Below is the error
Failed to save modification to the server. Error returned 'Microsoft.ACE.OLEDB.12.0' is not registered. The following system error occurred: Class not registered A connection could not be made to the data source with the Name of 'Excel Org_Structure_PowerBI'.