Hi,
I have 5 tables linked through PowerPivot now, but I'm thinking of breaking some of them up, and adding more. I estimate having to use 27 tables - mostly facts tables. Has anyone tried this before? Is there any limit on how many tables PP can take, while still being reasonably fast?
Thanks!
Sreedevi
Hi Sreedevi,
I'm not aware of a hard limit on the number of tables, but I'm concerned that you want to break up fact tables. This is the wrong direction. You should aim to have one or two fact tables and lots of dim tables. Of course you may have more fact tables than that but it would be a huge complex model.
Power Pivot is fast when there are tables containing lots of duplicates e.g. fact tables, since it's able to compress duplicates in a table very well. If you split thse tables into more tables then it can't compress as efficiently, not to mention I expect your DAX functions etc. will become very complicated.
I don't recommend this approach.
Mynda
Thank you for the quick response, Mynda! I won't go down that path then. 🙂
