Power Pivot, Power View and Power BI ?

JonathanJohns

Hi,

I guess you already know the most story about them from the official documents. Let’s talk about this from daily use.

1. Professionalism. Microsoft Excel is  a spreadsheet star. In most cases, Excel is a container of data. Power View and Power Pivot give more power of data analyzing to Excel, which already has many analysis functions. Power BI is born to do data analysis. Obviously, Power BI is more powerful.
2. Capability. 1 million rows is almost the limit of Excel while it’s a little cake for Power BI.
3. We can get data from many data sources directly with Power BI, we can publish the report to Power BI Service so that collaboration is much easier.

At last, Power View and Power Pivot just extend Excel while Power BI is a new product. Hope this would be a little help.You still can reference the official documents here: 

https://support.office.com/en-us/article/Power-Pivot-Powerful-data-analysis-and-data-modeling-in-Excel-a9c2c6e2-cc49-4976-a7d7-40896795d045?ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/article/Power-View-Explore-visualize-and-present-your-data-98268d31-97e2-42aa-a52b-a68cf460472e

Best Regards!

Dale

Hi JonathanJohns,

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

Best Regards!
Dale