Understandably, I was very excited to find Analysis Services as a supported Power Query data source as of November update of the product (those familiar with the Business Objects connector will find the interface to be very familiar). I am running SQL Server 2014 on my machine and have the corresponding version of the ADOMD.NET installed as well. However, when I tried to connect to my AS cubes I got the following error message:
Apparently, the connector requires the version form the SQL Server 2012 SP1 Feature pack. You can find the required version at this link (please make sure you install the correct 64 or 32 bit version of the file)
business intelligist 