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.
Good morning again, everyone.
One more question, if I may.
Is there a way to freeze some data in Power BI?
In this case, I've calculated some results for Oct. Next month I'll update the dashboard with the new data for Nov, but I'd like the results for Oct to remain, the problem is that the data will all recalculate using the new data for this month and, thus, change the results for Oct.
I could create "Data Jan", "Data Feb"... But in the long term, doing that is going to bite me in the backside, as the files become larger and larger until, finally, the whole dashboard is unusable. Is there a simple way for me to tell Power BI that I want X calculation result kept even after the data is updated?
Thanks, everyone.
Solved! Go to Solution.
If you have Premium, you could do incremental loads. Otherwise, you would need to create a query for each and after loading turn off data load for that query as you suggest.
If you have Premium, you could do incremental loads. Otherwise, you would need to create a query for each and after loading turn off data load for that query as you suggest.
I was afraid that would be the solution.
Thank you!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |