Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Auto exist import error

I am trying to import data from Analysis Services. However I get the "Auto exist operation is exceeding permitted limit" when importing several data tables. Traditionally these tables exist in a cube...
  • vanessafvg's avatar
    vanessafvg
    8 years ago

    Anonymous to be honest, in my experience but i could be wrong that is to do with a cube that has been  badly modelled potentially  or you have a lot of dimensions that are very wide, with lots of columns,  I recommend understanding memory, you need to view your task manager and see how much memory is being used.  Do you need all the data in the cube, im talking from a field perspective rather than rows (range of data)