Microsoft Releases Excel 2013 BI Stability improvements

Microsoft just released a major stability improvement for Excel 2013. Please read this post here for details. If you have Office 365 you can get this update by clicking on File->Account->Update Options->Update Now. However, many enterprise customers still chose not to deploy Click-To-Run version of office, in which case, there are links to four Knowledge … Continue reading Microsoft Releases Excel 2013 BI Stability improvements

Power BI Tutorial: Generate ID field using Power Query

This tutorial is based on one of the earlier tutorials – How to Create a Star Schema Model. I strongly recommend that you go through it first to become comfortable with using Power Query to create facts and dimensions for your Star schema before we start working on ID generation. The data set that we'll … Continue reading Power BI Tutorial: Generate ID field using Power Query