Hi,
The articles are not published yet - I presume that the links will start working as each article appears on SSC.
Regards,
Adam

Hi there,

Thanks for the comment and I am glad that this was useful.

160 M records - wow!

All the best,

Adam

Thanks Alan - much appreciated!

Adam

You are right that it is not instantaneous - but with the May 2016 update to Power BI Desktop you can now create Power BI templates - and so carry...

Hi Duncan,

I chose DAX here simply because Power Query solutions have been discussed elsewhere so well. I use either, depending on the scenario.

Adam

Hi Hikmer,

There are many ways of adding time intelligence to Power BI dashboards - this is only one among many - in fact I describe how to create Excel-based tables...

I once had a Triumph TR4 - what a motor!

The apogee of British engineering, it added real joy to driving. Not to mention the surprise factor if you turned the...

Hi Alexander,

Absolutely right - in fact I described this (really cool) tool in the previous article referred to at the start of this one.

All the best,

Adam

Hi John,

I am used to using modulo as it is nicely deterministic and easy to extend to several parallel processing IDs.

But anything is good if it works!

Adam

Hi iposner,

You are absolutely right, the source is a bottleneck.

Watch out for an upcoming article where I show some solutions to handle this for both database and file data sources.

Regards,

Adam

Hi Badatthis,

This is a direct load into a database, not a data staging approach - it just loads faster due to parallel loading.

All the best,

Adam

Hi Louie,

The balanced data distributor works with all versions of SQL Server from 2008.

Link to 2008 version here:

http://www.microsoft.com/en-us/download/details.aspx?id=4123

All the best,

Adam

Hi John,

Perhaps I need to caveat the concept of "reusable". By this I mean that you do not have to rebuild the date selector for every report.

You will, however, have...

Hi Robins80,

The code here is to go into the database from where the SSRS report will read the data.

If you download the sample file you can see this in the...

Hi Biz,

To combine the two you set the reportingyear and reportingmonth parameters to visible = false in the slicer report described in the previous article.

This has the effect of "replacing"...