Skip to content

DirectQuery white paper published

April 13, 2012

Today Microsoft published a white paper that I wrote on Using DirectQuery in the Tabular BI Semantic Model. The paper is 46 pages long, and it covers everything from model development to partitioning strategies to security to configuring SharePoint environments for DirectQuery.

I learned a lot writing this white paper. The most interesting part (to me at least) are the sections of the white paper where you learn how to replace time intelligence functions in DirectQuery models. I’m sure that you DAX experts out there will come up with even cleverer solutions over time to work around the formula limitations for DirectQuery, but hopefully the formulas I wrote are a good starting point. You will get the most out of these sections if you are already familiar with DAX.

I hope you enjoy it, please send any feedback on it to either me or Microsoft.

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: