SQL - Excelerator BI

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 …

How Query Folding Works 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 …

Extract Table Size from Power BI Desktop Using DAX Studio 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 …

DMV to Extract Measures from Power Pivot 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 …

Use Simple SQL to Manage your data in Power Pivot 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 …

DAX Studio 2.0 released today 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 …

Problems Importing Access and Excel 2010 into SQL Server 2012? Read More

Scroll to Top