Forum Discussion
Problems adding data to Power Pivot Model
Hello,
I am trying to bring in data into my PowerPivot model from Excel. My data looks like this:
Date Number Re-model
| 6/1/2018 | 1806049 | |
| 6/1/2018 | 1806048 | |
| 3/1/2018 | 1803021 | |
| 3/1/2018 | 1803022 | |
| 3/1/2016 | 1603013 | |
| 11/1/2004 | 1 | 2/1/2016 |
If I try to refresh my table in PowerPivot, this will accept, if I change the last number to 510015
| 6/1/2018 | 1806049 | |
| 6/1/2018 | 1806048 | |
| 3/1/2018 | 1803021 | |
| 3/1/2018 | 1803022 | |
| 3/1/2016 | 1603013 | |
| 11/1/2004 | 510015 | 2/1/2016 |
I get the error message "We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server". If I replace 510015 with say 2, the refresh does not create an error.
Any ideas? I have tried copying the format down from cells higher above to see if that fixes anything but no luck.
Thank you.
No Replies