Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |