Forum Discussion
Solved
file replace automatically
i get date from sharepoint folder and there will be 2 file for the 1 Powerbi Table. and the 2 file is version 1 and version 2. Now the default is the version 1 and version 2 file will be "append " ...
When you connect to the sharepoint folder, you sort the file list by an appropriate criteria (for example file name descending) and then you grab the binary of the first row, like #"Sorted Rows"[Contents]{0}
When you connect to the sharepoint folder, you sort the file list by an appropriate criteria (for example file name descending) and then you grab the binary of the first row, like #"Sorted Rows"[Contents]{0}
sounds a practicable approach ,i will try that and accept this as a solution when it works.
