I installed SQL Server 2012 SP1 Data Mining add-in for Excel 2013 64 bit on Windows 8.1 64 bit Enterprise. I then ran "Getting Started" to complete the add-in setup and connect to the SSAS DB. After I opened the "Sample Excel Data" file to test I noticed the "Table Analysis" tab under "TABLE TOOLS" appeared on the ribbon blank (without the text "ANALYZE" on the tab). When I clicked on that tab I was able to see the "Table Analysis Tools" buttons but I keep getting the "Object reference not set to an instance of an object" error message when I try to run any one of them and exiting out of Excel disables the data mining add-in. Is this a known issue and if yes is there a hotfix available? Thank you.
The SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office released on 09/01/2013 may have compatibility issue with Windows 8.1.
I suggest that you update the SQL Server 2012 to the latest version by installing Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1, and keep the Windows 8.1 update.
Additionally, you can considering submitting a feedback at https://connect.microsoft.com/sql.