Forum Discussion

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

Redundant tables in model

Hi,    I have several tables in my report that are redundant once the data is transformed in Query Editor. And I am looking for ways to minmise the performance impact   Here's the situation: The...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Having 10 identical tables as a your source is fine if it is best for your business.  First thing to do is to right click on each of those 10 tables and uncheck "Enable Load".  That will keep them from loading into your model., but they will still be used in refresh.  See how much that improve performance, but if all your analysis is only on table 11, it may not help much.  Hopefully it will.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

Thanks mahoneypat - unchecking Enable Load seems to be the right option at the moment. There's a slight improvement.