Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My PBI dashboard is scheduled to refresh ~8 hours with data from SFDC. I'd like to display the changes in various (pipeline/forecast/won) metrics versus the previous day.
Example: Tuesday's 8AM dashboard compares against Monday's 8AM, Tuesday 5PM compares against Monday 5PM, or Monday 8AM- since deals aren't moving that fast).
Is this possible? I'm being told that I'll need to manually save yesterday's data because the scheduled refresh wipes the data and replaces with new data. Is there a way to automatically "lock" data from a previous refresh?
thanks! -TF
What you are being told is correct. No real way around it other than perhaps some fancy, tricky M code maybe?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |