Data refresh not getting all data/stopping early

[davidpOuray]

Hey all,

I am using a data-load based report file that queries our datawarehouse for all of its data. It has been working great for months now, but recently when I refresh the data it seems to sporatically gather some of the data and then quits early so various parts of my report are not working. If I refresh again, it might collect more/less data, but its definitely not getting all of it like it used to. Nothing has changed as far as our datawarehouse.

The file size is currently only ~18MB and I am not dealing with a huge amount of data, definitely less than a million rows.

Any ideas?

[davidpOuray]

After further troubleshooting, I noticed it has to do with the fact that the report file is on a network share.

I have moved it to my local PC to refresh and it works fine. Hopefully this helps someone!

UPDATE: Nope, still not working. I just got lucky I think one time 

[davidpOuray · Accepted solution]

Ok, I finally solved it.

It was a new data abberation causing a dupe primary key. It just wasn't very clear what the problem was, since I thought it wasn't getting the data and thats why it giving errors on a bunch of calculated/measure columns...trickle down.