Blog Posts

Azure Machine Learning

Azure Machine Learning

At the PASS Summit last month, I showed off an Azure Machine Learning model which predicted how well a conference session would do based on its title. The model was part of my BI Power Hour demo, and unlike my usual Power Hour demos about cats and ponies, it bordered on actually being useful. During … Continued

Parsing Binary data using Power Query formulas

Parsing Binary data using Power Query formulas

The Power Query formula language (M) contains a number of library functions that allow you to parse binary data. You can use these functions to build queries which parse custom binary file formats. This post contains two samples – a simple query which parses X & Y coordinate values from a binary field, and a … Continued

Iterating over an unknown number of pages in Power Query

Iterating over an unknown number of pages in Power Query

My previous blog post showed how to iterate over a set of web pages in Power Query using a parameterized function. The post contained two queries – the GetData function, and a query to invoke it over a set number of pages. GetData function

Query to invoke it

This approach uses a pre-generated … Continued

Defining Configurable Settings for your Queries

Defining Configurable Settings for your Queries

(The information in this blog post is current as of the March 2014 release of Power Query.) The Problem A colleague sent me a copy of the Excel workbook they used for a blog post about using Power Query with Project Online (see the fantastic article: Creating burndown charts for Project using Power Pivot and … Continued

OData Source for SSIS

OData Source for SSIS

A new OData Source for SSIS is now available. The 2012 version is available as a standalone download, and the 2014 version is part of the SQL Server 2014 Feature Pack. OData Source for SQL Server 2012 OData Source for SQL Server 2014 The documentation for the 2012 is available in Books Online.

Presenting at SharePoint Conference 2014

Presenting at SharePoint Conference 2014

I’m looking forward to attending and presenting at my first SharePoint Conference next week in Las Vegas! I’ll be presenting two Power BI deep dive sessions (1): #SPC397 – Deep Dive on the Data Management Gateway in Power BI for connectivity to on premise and hybrid scenarios The Data Management Gateway is the key to … Continued

Creating a Date Dimension with a Power Query Script

Creating a Date Dimension with a Power Query Script

Chris Webb has previously blogged a similar approach, but I thought I’d shared my own version of a Power Query function that generates a table of dates that could be used to create a Date Dimension. I first saw Faisal Mohamood do this in our end to end Power BI talk at the PASS Summit, … Continued

Using Hive ODBC from SSIS

Using Hive ODBC from SSIS

Microsoft announced the general availability of Windows Azure HDInsight last week, and released an updated version of the Microsoft Hive ODBC Driver. This post describes how to use this driver to pull data from your HDInsight cluster with an SSIS Data Flow Task. Installing and Configuring the Hive ODBC Driver The download page for the … Continued

SSIS Content from PASS Summit 2013 on PASS TV

SSIS Content from PASS Summit 2013 on PASS TV

You can now stream sessions from the 2013 PASS Summit on-demand from the PASStv site. There’s a lot of amazing content on there, including the Day 1 and Day 2 keynotes. If you’re interested in SSIS (and if you’re reading this, there is a good chance you are), there are two SSIS focused sessions available: … Continued

SQL Server Data Tools – Business Intelligence downloads

SQL Server Data Tools – Business Intelligence downloads

(update 2014/11/14: added link to the VS 2013 release which came out in April) Looking for the SSIS development tools? Formerly known as Business Intelligence Developer Studio (BIDS), the designer is now called SQL Server Data Tools – Business Intelligence (SSDT-BI) (not to be confused with the other SQL Server Data Tools). The version you … Continued

BI Power Hour at PASS Summit 2013

BI Power Hour at PASS Summit 2013

A big thank you to the PASS Summit 2013 attendees who made our BI Power Hour a great success! I have to admit I was a little worried when we lost all power 15 minutes before the session started (highly ironic that we lost power before the BI Power Hour devoted to Power BI), but … Continued

SELECT * From SSIS.DataFlow

SELECT * From SSIS.DataFlow

If you’ve been looking through the documentation for the Power BI preview, you might have noticed a section on Publishing SSIS Packages as OData Feeds. This functionality lets you create a T-SQL View over an SSIS data flow using a new SSIS add-on called the Data Feed Publishing Components. This add-on works with SQL Server … Continued