Blog Posts

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

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 want will depend on two things; your version of SQL Server, and the version … 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

PASS Summit 2013

PASS Summit 2013

Wow, has it really been two months since my last blog post? I guess I’ve been busy! I’ve been hard at work on SSIS and some components for Power BI. I hope to blog about all of the fun projects I’ve been working on this past year, but in case I don’t get a chance, … Continued

Filtering in Data Explorer

Filtering in Data Explorer

I was been manning the Data Discovery & Visualization and Data Warehousing booths at TechEd Europe last week, and we saw lots of excitement over Data Explorer. One of the questions I got was about how Data Explorer does its filtering, and I realized there hasn’t been much shared about this yet. It seems like … Continued

Server Execution Parameters with DTEXEC

Server Execution Parameters with DTEXEC

The SSIS team blogged about executing packages deployed to the SSIS Catalog using DTEXEC a while ago. The post mentions the $ServerOption::SYNCHRONIZED parameter as a way to control whether the execution is synchronous or asynchronous, but there are some other server options you can set as well. Phil Brammer actually blogged about the options last … Continued

SQL Saturday Dublin – this weekend!

SQL Saturday Dublin – this weekend!

Less than a week to go before the next SQL Saturday Dublin event! I’ll be presenting a fun session at the main event (Cats, Facebook, and Online Dating with Microsoft BI), and doing a full day training session this Friday (6/21). If you are interested in learning more about SSIS, DQS, and MDS, please see … Continued

Bulk Loading into MDS using SSIS

Bulk Loading into MDS using SSIS

Each entity in SQL Server 2012 Master Data Services (MDS) will have it’s own staging table (stg.<name>_Leaf). Using this staging table, you can create, update, deactivate and delete left members in bulk. This post describes how to bulk load into an entity staging table and trigger the stored procedure to start the batch import process. … Continued