Did you notice the update to Power Pivot in Excel 2013? Did you know that one was available? Neither did I until I heard about it 2 weeks ago. It… Continue reading Power Pivot Updates to Excel 2013 – November 2013
Tag: Excel
Changes to Data Loading in the November 2013 Power Query Update
Last week, Microsoft released a new version of the Power Query preview for Power BI. It’s a significant update and contains some welcome improvements. I’m not going to list them… Continue reading Changes to Data Loading in the November 2013 Power Query Update
Analyzing Data with Power BI from Beginning to End
I’ve been writing a fair bit lately about specific aspects of Power BI, and how they all fit together. I decided to put together a “real world” demonstration of as… Continue reading Analyzing Data with Power BI from Beginning to End
How To Load Data Directly Into the Excel (Power Pivot) Data Model
In a recent post, I discussed that while Power BI sites allow for data models up to 250 MB, the size of the worksheets portion of any workbook cannot exceed… Continue reading How To Load Data Directly Into the Excel (Power Pivot) Data Model
Power Query Navigator Can Only View 2,000 Items, and Other Limits
I was preparing a demonstration using Great Plains data when I came across a curious limitation. Great Plains isn’t exactly efficient with its use of tables, and this database had… Continue reading Power Query Navigator Can Only View 2,000 Items, and Other Limits