The problem: While trying to import an excel file into an SSAS model, I kept getting the following error: Failed to save modifications to the server. Error returned: ‘The provider ‘Microsoft.ACE.OLEDB.12.0’ is not registered. The following system error occurred: Class …..
I’ve built this using the tableau desktop version. The only value add here, is that it will connect to various other data sources. Effectively, it appears to be the same tool.
It’s ugly as sin, but this is just a POC.