Forum Discussion

davidpOuray's avatar
davidpOuray
Frequent Visitor
10 years ago
Solved

Data refresh not getting all data/stopping early

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 sp...
Need Help
  • davidpOuray's avatar
    davidpOuray
    10 years ago

    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.

davidpOuray's avatar
davidpOuray
Frequent Visitor
10 years ago

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 :smileyfrustrated:

  • davidpOuray's avatar
    davidpOuray
    Frequent Visitor
    10 years ago

    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.