Recap POWER BI thru Iterations

Power BI has seen so many iterations probably no other enterprise MSBI product has seen.

Power BI Stage 1

  • Power Pivot Excel 2010 add-on
  • Power View in SQL Server 2012/SharePoint 2010
  • Power Query add-on for Excel 2010

Power BI Stage 2

  • Excel 2013 – Power Pivot, Power Query, and Power View (as well as the new Power Map) are all integrated
  • ETL the data using power query
  • Model in Power Pivot
  • Visualize in Power View

Power BI Stage 3

  • Then a cloud based version without having the SQL or SharePoint licenses, using o365
    Q&A
  • Natural language processing
  • oData feed to query on premise environments

Issues:
1) Still had issues with multiple editions of o365
2) Usage of silverlight which had browser compatibility and mobile rendering issues
3) Cannot add calculated measures without going back to the power pivot model

Power BI Stage 4

  • Dedicated power BI site created with no hassle of o365 editions
  • Easily accessible and cheaper
  • Standalone power BI designer (It has Power Query, Power Pivot, Power View)
  • The file is created in pbix format and can be uploaded straight to power BI site.
  • HTML5
  • ios app for power BI
  • Power view interface allows addition of new fields using DAX
  • Reports and dashboards have different interface (like other visualization tools like tableau & qlikview)
  • Dedicated feedback forum for additional features (wow not another connect link)

Issues:
1) Data refresh is limited to excel which uses power query or tabular model but no direct refresh from SQL Server or Cubes or other RDBMS
2) Limited Q&A Support
3) No export options at all (export to PDF ranks top as user feedback as of today)
4) No tooltips on hover

But since the development on power BI is much more agile than other products (may be like SSRS) we can potentially expect most of feedback might go into product development quite quickly.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>