Did you, by chance, drop a Matrix into your report design surface instead of a Tablix? Try them side by side to see the difference.

You don't do anything different. The combination of the partition scheme and function determine the partition the record will be written to. SQL Server handles all that for you....

It appears that Steve Jones (the guy that runs this show... I mean website) wrote several articles about tSQLt. This is the first one[/url]. Try reading some of...

I think the one migration/upsizing path that is not available is from PowerBI Desktop to SSAS.... so of course, that's what I did. Just seems strange that you can...

Will do. I guess I'm still a serious noob when it comes to DAX... just getting my head around the way it works is hard!!!

I was thinking I should just...

Bummer. That's what I was afraid of.

What do you do if the model is missing a measure or two and maybe some useful calculated columns? Call the developer, because...

Looks like this should do it...

http://stackoverflow.com/questions/11301383/automatically-drop-and-recreate-current-indexes

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? DISABLE'

and

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? REBUILD'

is all you need if you want to do it for...

Open SSMS.

Right-click the Databases folder in Object Explorer. One of the options is ATTACH. It should prompt you for file locations of the data and Log files

Do you mean a primary key?

did you not try attaching them? (Don't forget the log files).

Okay... having added a bunch of references about partitioning, read this one[/url] first... It's Gail Shaw's... (don't know why I didn't start there!). Be sure you understand what partitioning...

Is there a good beginner book on Multi-Dimensional / Tabular? I've been playing with DAX for a while (and I'm still terrible at it!)

Especially one that covers security/RLS.

Per Joey D'Antoni. About face, go back to Excel, upsize from there. There's a hack, but for what I'm doing, not worth the hassle.

Hi,

Welcome to SSC. Since you're new and your question isn't entirely clear, perhaps reading one (or both) of these articles will help us to help you.

How to post...

Where's the PARTITION BY Company part of your query? PARTITION BY is analogous to GROUP BY... and it seems to be missing, so the totals/counts won't "restart" when the Company...