Comments
I've also been advised by MS support to log this under the Cross-Apps category. The comment box doesn't seem to allow me to insert actual links (seeing it as "malicious input" even when using the WYSIWYG link tool), so have to provide URL as text: https://experience.dynamics.com/ideas/idea/?ideaid=7deebb8c-adb7-ef11-95f5-6045bd82f293
Some of our data is lagging by more than a couple months behind other sources. To make updates work automatically, in the source of current value, I specify a range in the past to pull in. I use a year's worth of data, so I add conditions that the consumption end date "Last x months" = 15 and also "Older than x months" = 3. That way it avoids dates for which we don't have data yet, but it also automatically pulls in new data each month.