Power BI Suite and PowerBI.microsoft.com


Microsoft Power BI suite of tools have been expanding over the years.

Power Pivot has been on the market for a while.

Power View is relatively new. 

Power Query requires a download from Microsoft: https://www.microsoft.com/en-ca/download/details.aspx?id=39379

Power Map is still on preview:  http://www.microsoft.com/en-ca/download/details.aspx?id=38395

To enable these features, go to Excel -> File -> Options -> Add-Ins -> COM Add-ins -> Go


http://powerbi.microsoft.com/ is still on preview, and the direction makes sense since all the desktop analysis (Excel Add-Ins) has memory limitation. The PowerBI.com doesn't have the constraints and can power very complex analysis and handle huge data size.



Microsoft Power BI Designer is available for download from the site: http://powerbi.microsoft.com/downloads

And don't forget to check out PowerBI blog: http://blogs.msdn.com/b/powerbi/

Comments

Post a Comment

Popular posts from this blog

Project Professional 2013 Error 12015

Image
Got an error 12015 when opening Project Professional 2013.  Clicking the More info and it shows this: <detail><ServerExecutionFault xmlns="http://Microsoft.Office.Project.Interfaces/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Actor i:nil="true"/><LastError>12015</LastError><Message/><Source/><StackTrace/><TargetSite i:nil="true"/><ExceptionDetails><errinfo xmlns=""><general><class name="ActiveCacheUnsupportedProjectProfessionalVersion"><error id="12015" name="ActiveCacheUnsupportedProjectProfessionalVersion" uid="315f3c6b-46fa-e411-80d9-00155d106504" version="15.0.4569.1504"/></class></general></errinfo></ExceptionDetails></ServerExecutionFault></detail> and the second error message is: According technet ( http://blogs.technet.com/b/p
Read more

SP optimization with TVF, View

Had problem with a SP, SP has a few parameters SP unions three queries and then filter by a parameter and then return data  One of the three queries links a TVF with a few tables The TVF links a standard view with a few tables The View links several tables, however not all tables are used by the TVF Symptom: One table used by the TVF has many scan count and slows down the SP Optimization options: Bring the parameter to the three queries referenced by the SP - no effect Modify the TVF and pass in the SP parameter - Speed up 4x Replace the view with the base table and remove unused tables - Speed up 4x
Read more

Unable to initialize the Shared Memory listener. Access is denied

SQL Server failed to start  Run SQL Server from command line and shows this error: Unable to initialize the Shared Memory listener. Access is denied Cause: When the SQL Server starts it tries to open listening named-pipes to accept client share memory or named-pipe connections. If the listening named-pipes are not closed properly during the last shutdown of SQL Server (maybe after a forced kill of the SQL Server process), there will be orphan named-pipe handles in the windows kernel file system. To solve this issue, a quick solution will be to reboot   the host machine.
Read more