Setting up Power BI Excel features

This is the second post in the Power BI category. In this post I explain how to setup Excel environment to user Power BI Excel components. Power BI offers 4 individual Add-ins for Excel.

They are Power Pivot, Power View, Power Query and Power Map

Power View and Power Pivot are available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013  You do not need to perform a separate installation you just have to activate them. But you have to download the Power Map and Power Query.

Power Query Download Link : http://office.microsoft.com/en-us/excel/redir/XT104104542.aspx

Power Map Download Link : http://office.microsoft.com/en-us/excel/redir/XT104048049.aspx

Once installed you should activate they aren’t activated by default. To activate the Add-ins (all the above Add-ins are COM Add-ins) click File and then Options; select the Add-Ins tab and select COM Add-Ins in the drop down.

image

 

Click Go and you will get the list of available COM Add-ins. Select the above 4 Add-ins and activate them. Power Query and Power Pivot reside in their own tab while Power Map and Power View are available under the Insert tab. If you do not have Silverlight installed in your machine you should install Silverlight in order to make the Power View work.

image

 

image

 

image

Now your Excel environment is enriched with the Power BI Excel features.

Advertisements

Comments are closed.

Powered by WordPress.com.

Up ↑

%d bloggers like this: