Forum Discussion
Import daily excel report and adding rows in same table
Well if there are separate tables for separate files, you can use the below option to exclude the previous files form the refresh.
However in your case as it is only one table containing all excel files data, there is no way you can restrict the refresh for few.
It can be possible if you load the files once and keep the pbix file for future use, however you need to load the latest data as well and refreshing the data will delete the data of files which are not present at the folder loacation.
I hope I was able to clarify it for you!
Thank you so much for your prompt reply and it helps me a lot. Is this works, if old files after completing a month deleted from folder? I would like to accumlate the all the data and store it in a query, whether those files exist or not in the folder. Request you to support
Well if there are separate tables for separate files, you can use the below option to exclude the previous files form the refresh.
However in your case as it is only one table containing all excel files data, there is no way you can restrict the refresh for few.
It can be possible if you load the files once and keep the pbix file for future use, however you need to load the latest data as well and refreshing the data will delete the data of files which are not present at the folder loacation.
I hope I was able to clarify it for you!