I have a lot of experience with relational database design like MS Access, but am fairly new to Power Pivot and am finding my workbooks are taking a long time to refresh. I've been building some complex models and my latest is taking 10 minutes to update all. I have maybe 30 queries, many referencing each other. I tried to do further calculations and that then took 20 minutes to update and give me an error. I've been trying to keep all my queries in the data model until I need a final output. Is it best to output result 1 to a table and then reference that instead of a query in the data model to calculate result 2?
WHAT IS THE BEST WAY TO STRUCTURE A POWER PIVOT MODEL?
Thanks in advance.
Carl in Sydney
