When I leave the box unchecked, the Pivot Table runs fine.
When I check the box, I sometimes get a user map error that has my user name then AppDataLocalTemp and ends with Model.53.cub.xml. It sometimes comes initially and other times comes during the relationship.
With more complicated models, it happens all the time.
Greg
Hi Greg,
I've not heard of this error before but a Google search turned up this thread which suggests it was due to virus scan by Trend.
Have you tried loading the data to Power Pivot/Data model via Power Query?
Mynda
Thanks Mynda for your help!
I have sent this to our IT department that controls our OfficeScan settings.
To answer your question, it showed up first in PowerPivot, then Pivot Tables, and also Get and Transform when adding to the data model.
This has been driving me nuts so thanks for pointing me in the right direction.
Greg
You're welcome, Greg. Hope they can fix it for you.
