Daniel Wikar Personal blog about Analytics, Big Data, Microsoft and IT

Install Data Mining Add-in In Excel 2016

Ever since the release of Excel 2016 a compatible SQL Server Data Mining Add-in has been missing. There has been numerous requests for Microsoft to release an official update but so far this hasn’t happened.

Having Excel 2013 and Excel 2016 installed side-by-side has been used as a workaround to get the Excel 2013 DM Add-In semi-working also for Excel 2016. The following registry hack is allowing the otherwise blocked installation to proceed for Excel 2016 without the need for an actual Excel 2013 installation.

  1. Download Microsoft® SQL Server® 2012 SP4 Data Mining Add-ins for Microsoft® Office® (Latest official version)

  2. Insert the following entry in the Windows registry (.reg file here but use at your own risk) excel2016-hack

  3. Proceed with installation which now shouldn’t complain about missing Excel 2010/2013


Power BI - Confirmed to be available on-premise within SQL Server 2016

In my opinion one of the most interesting outcomes from Microsoft Ignite 2016 is the confirmation that Power BI will be available as an on-premise feature within SQL Server 2016 (Reporting Services). As usual we didn’t get any ETA apart from “we’re not too far off” and “in a not too distant future”.

Link to full video: Create a modern enterprise reporting and mobile BI solution with SQL Server 2016


ERP World View


During my career I have encountered numerous different ERP systems, vendors, consultants and specialists. Something that has struck me as common for many (but not all) ERP professionals is the lack of understanding for the need of other enterprise applications and/or integration of the same. Many also seem to favor customizations within the ERP rather than making it a part of a service-oriented landscape with other enterprise or business unit specific applications.

“Documentation? Well, we do have some ER diagrams but they’re not complete or up to date.”

“Why would you like to extract data out from the ERP?”

“Services? Interfaces? We’d suggest you to take a look in the database if you really need some of our data.”

“We already have that in our ERP, not as good but it would still be better to use that.”

“Integrate? Wouldn’t it be better to just migrate the data into the ERP?”

Anyone with similar experiences or maybe the opposite?


Power BI Desktop/Azure now supports SSAS Multidimensional

Ever since the possibility to create a data source connecting Power BI to an on-premises SSAS Tabular instance the same was requested for Multidimensional (MOLAP) cubes and now the time has finally come!

Details on how to connect it through Power BI Desktop can be found here: Connect to SSAS Multidimensional Models in Power BI Desktop

Setting up the Power BI Gateway: Manage your enterprise data source - Analysis Services


Reblog - Datazen now able to use MDX generated by SSMS

Since the latest release Datazen is now able to use MDX queries generated through SQL Server Management Studio. Christopher Finlan wrote about it is his blog post New Datazen Server Build Brings some MDX Magic and no use repeating the same here so I’ll just post the link as a reblog.

Happy dashboarding!