Power BI Lost Features & Functionality Tracking

With the most recent release of Power BI Desktop / Services and removal of dependencies on Excel, we have lost several features and functionality.  However, the gains and improvements far outweigh the losses.  We gained funnel charts, gauges, donut charts, filled maps, treemaps, waterfall charts, dual axis line and column charts, area charts, custom titles, custom … Read more

How to Profile SQL Server Data Using Power BI

With the announcement of General Availability for Power BI 2.0, Microsoft made BI to the masses possible. There were some steps back (chart/map drill down, tile slicers, etc.) but many more steps forward. They removed the reliance on Excel, added formatting options, new visualizations, and more. With the new release, we wanted to create a … Read more

Power View for Power Pivot / Tabular Data Models

Power Pivot or SSAS Tabular data model optimization is important for Power View reporting usability and functionality. In this posting, we will discuss the following topics: X-Axis Guidelines Advanced Properties Image Handling Data Categories Table Behavior Field Behavior   X-Axis Guidelines Data type and distribution Utilize a number or date that increases uniformly (primarily for … Read more

Power View Data Model Optimization

Before a Power View report can be built, you have to have a data model built as a data source.  There are several configuration options to help optimize your data model specifically for Power View.  These configurations and/or optimizations are made within your Power Pivot model or in SQL Server Data Tools on the SSAS … Read more

DAX Best Practices

DAX Best Practices  are vital when utilizing large data models and looking to improve performance.  You can get away with poor practices on small models but you will see performance issues as your data grows. Data Analysis Expressions (DAX) is the native query and formula language for Microsoft Power Pivot data models and SQL Server Analysis … Read more

Power View Best Practices

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. It is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010 and 2013 Enterprise Edition. Power View in SharePoint is browser-based Silverlight application, a feature of the SQL Server Reporting Services Add-in for Microsoft SharePoint Server. Creating, opening, … Read more

Power BI Preview

I am so excited for the future of Microsoft BI.  On January 27th, Microsoft unveiled a new Power BI Preview (link) offering that I believe will radically change the BI atmosphere. Since the Power BI inception, the biggest drawback has been its pricing.  Power BI can now compare to Tableau, IBM, Qlikview, and Spotfire pricing. … Read more