Solving Spotify Daily Append Error
If you find that your Spotify sources are only successfully appending every other day, the answer is as simple as changing the lookback days to 1 in the source settings.
- Verify that the Spotify error is related to a time Dimension Error by clicking on the failed load.
- The text should contain the error: "Time Dimension Error: Report Start must be before Report End. LIFETIME granularity requests are truncated to the start of the day."
- Now that you've verified that the error is related to the date range, open the settings of your project.
- Scroll down to "Other Settings" and change the look back days to 1
- Click "Save"
- Hit the retry button on the right side of the source load