Thx Steve and pietlinden.  I already hooked power bi (pbi) up to the model directly and saw positive results both visually and performance wise.  I'm not a big fan of...

Thx Steve.  All contributions are welcome.  Below is a picture of the star.  I am not committed to the star, tabular, ssrs, power bi, excel, tableau, column store index, multidimensional etc.   I'm...

repairing (without uninstall) just vs2010 from the installer didnt do the trick. Back to the drawing board.

yes, unless I'm missing something. It seems like the pipes (if they really are delimeters) are just part of one big data "column" to your process.

I've used...

can you store the proc names in a table, direct them with exec and params via appropriate query to an ado data set, loop thru the ado data set building...

its looking more and more to me like vs's list of "add in/macros security" paths isnt turning up the necessary xml file where the key to finding system.data (framework's...

sure.

When indicating conn mgr is new in edit mode on destination component in data flow, "the new connection manager could not be created. Additional Information: The DbProviderFactories...