Archive - Blog Posts on SQL

How Query Folding Works - Level: Beginners Power Query is a product that allows business users to extract data from any source, cleanse and transform that data, and then load the modified data to a new location, typically into an Excel spreadsheet or a Power BI data model.  Power Query is very easy to learn, and most tasks can be […] Read More
Extract Table Size from Power BI Desktop Using DAX Studio - I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others.  I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version of DAX Studio can be […] Read More
DMV to Extract Measures from Power Pivot - I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities.  These are both excellent tools in their own right and I encourage you to read up on those previous articles to learn more about these tools. Today however I am going […] Read More
Use Simple SQL to Manage your data in Power Pivot - When I started learning Power Pivot, I learnt there are 2 ways to import data. There is the “standard way” that uses the table import wizard – good for us Excel folk. There is a second way that uses the Query Editor to write some SQL code and extract the data you need direct from […] Read More
DAX Studio 2.0 released today - Great news for Power Pivot for Excel users – DAX Studio has had an update over night and version 2.0 is now available. For those of you that don’t know DAX studio, it is an ADDIN that you install for Excel 2010 or 2013. It connects to the Power Pivot Data Model and allows you […] Read More
Problems Importing Access and Excel 2010 into SQL Server 2012? - Edit 10 Dec 2015: This blog post was written to solve a problem with SQL Server import drivers, however the process of addressing the issue should also work (in reverse) for people that are running 32 bit Office and want to install 64 bit Power BI Desktop.  If this is you, read on and you […] Read More