by Gil Raviv | Jun 28, 2017 | Data Chant
Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables, and highlights the changes in a third table. You can load new versions of the tables, click Refresh All in Excel,...
by Matt Allington | Jun 27, 2017 | Excelerator BI
Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data). The new capability makes it easier to combine multiple copies of similar workbooks into a single table without...
by Rob Collie | Jun 27, 2017 | PowerPivotPro
Awhile back I recorded a podcast with John Michaloudis from MyExcelOnline and it went live today. Fun chat, lots of excitement. We talk about all of the “beautiful accidents” which led me to where I am today. We talk about… The post Podcast with John Michaloudis!...
by Chris Webb | Jun 27, 2017 | Chris Webb
If you’re looking for classroom-based training on Microsoft BI, data science or SQL Server then check out the list of courses I have coming up at Technitrain this autumn: Introduction to Power BI, taught by me, September 25th-27th – a three day course covering the...
by Chris Webb | Jun 26, 2017 | Chris Webb
In the first two parts of this series (see here and here) I showed how Power BI/Power Query/Excel Get & Transform’s data privacy settings can influence whether query folding takes place or even whether a query is able to run or not. In this post I’m going to talk...