I believe this is backwards for the RELATEDTABLE bullet point:

"t allows you to traverse the model from many-side to any related tables on the one-side in the chain of one-to-many...

Great concept.  Very effective way of teaching DAX by comparing it to something we are all very familiar with already.   A little feedback.  I found it confusing sometimes when you...

Thanks Mr. or Mrs 500. It seems that I had just been staring at the code for too long. I did leave the "[dbo]" (schema) out. ...

I would consider adding a date modified column but the whole point of copying these tables is because I don't have admin. rights over them.... read-only. So, I am...

Thanks Phil. I thought that I was going down the right path (and for the same reasons). : )

Andy,

I am eternally grateful for Stairway series. But if someone points out a typo like the "Person.Contact" / dbo.Contact" issue, you should fix it. This happened in an...

Uh... wow, that was easy. It ran without error. I'm a relative newbie. Can you tell me why there was an error. Was it because that...

There is no Result_Set_Type property, but I imagine that it is referring to the Result Set value

Looks like it's: Full Result Set.

Alvin,

Thanks for the response! Wouldn't running a task be a one-time thing though? I want to run this package daily to make sure that the data in the...

Sue,

After reading your response, I started scouring the interwebs again and found a solution:

You alluded to it at the end of your last response, so you were on the right...

Version query result is:

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit)...

Nice catch! Wow, sometimes a fresh set of eyes is everything! Sorry to bother you for a silly typo... but THANKS!!!

I actually pass this query to the same Datamart to populate a different table in my PowerPivot model:

SELECT

v_dim_wotask_ES.wotask_id

,v_dim_wotask_ES.work_order_cd

,v_dim_wotask_ES.task_cd

,v_dim_wotask_ES.work_order_desc

,v_dim_wotask_ES.task_desc

,v_dim_wotask_ES.wo_status_cd

...