Power Query: Stand Alone Vs. Corporate version

One thing that caught me off guard as I was trying to use Power Query against Power BI for Office 365 was the fact that there are 2 versions of Power Query. This actually seem to have confused at least one other person already, so here is some information in case you face the same situation:
Microsoft Power Query for Excel - version 1.5.3296.2082
http://www.microsoft.com/en-us/download/details.aspx?id=39379
  Microsoft Power Query Preview - version 2.6.3387.121
http://www.microsoft.com/en-us/download/details.aspx?id=39933

How are they different?

Version 1.x is the first release of Power Query the one that reached General availability on July 8 2013. This means, among other things, it is safe to run it in production environments. This is also the “standalone” version meaning it does not have the options to connect and share Queries via Power BI for Office 365 Version 2.x is  the the so called “corporate” which means has the options to interact with Office 365 Power BI sites. It is important to note that as of this date, this version is in the  PREVIEW stage which is some sort of beta period where features and functionality are still being finalized  and its use in production environments is not recommended.   So, if you are trying to use Power Query for Excel against Power BI for Office 365 make sure you have the 2.x version!

Power BI for Office 365: Installing Power BI App from SharePoint Store

I got my invitation email to the preview of Power BI for Office 365 few days ago and while the provisioning process was pretty straight forward, I run into a minor issue that needed few extra steps that were not covered in the Power BI Provisioning Video. In my case, I did not have Power BI as one of the available apps of the team site I wanted to use as shown in the video (~3:45 in video). Fortunately, there is a provisioning guide document that provide the steps to manually install Power BI app from the SharePoint store.

Thanks to Gilad Elyashar  for pointing me in the right direction to get this issue solved by replying to my post in the power BI forum. If you run into this or any other issue, I encourage you to make use of the Power BI forums to get answer to your questions