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.
Hi Expert,
We are building the Power BI dashboard by combinining a Daily Excel file. Each day, there will be a Excel file that contains the data of that day. But as tiem goes by, the dataset becomes larger and larger which cause the refrehsing taking a long time.
Is there a way to only load the latest file while still keep the previous loaded data in the table?
For example, for today's refrehs, it just load today's file which previous days data is still kept.
Many thanks!
Best regards,
Tom
Solved! Go to Solution.
Hi @TomLU123,
Do you want to perform the incremental refresh? If yes so please refer the below article for incremental refreshing your data.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
If you find this helpful so please mark this as a solution.
Cheers!
Hi @TomLU123,
Do you want to perform the incremental refresh? If yes so please refer the below article for incremental refreshing your data.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
If you find this helpful so please mark this as a solution.
Cheers!
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 |
---|---|
109 | |
100 | |
84 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |