Nov 14 2018
10:30 AM
- last edited on
Jul 12 2019
11:16 AM
by
TechCommunityAP
Nov 14 2018
10:30 AM
- last edited on
Jul 12 2019
11:16 AM
by
TechCommunityAP
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.