Forum Discussion
Schedule Refresh/ Sharepoint Connector
When you append additonal CSV files to the semantic model using the Sharepoint Folder connector, how does Power BI know which CSV files are the new ones to append when it does the schedule refresh? Otherwise it will append the ones that have already been appended in the last refresh? Basically, how does Power BI identify the new CSV files?
Power BI doesn't know what you mean by "new" unless you tell it.
Standard procedure is to read ALL the files in the sharepoint folder and to include the file name in the appended output as a column.
Remember that SharePoint is NOT a folding source so Incremental Refresh will not give any performance advantage.
4 Replies
Power BI doesn't know what you mean by "new" unless you tell it.
Standard procedure is to read ALL the files in the sharepoint folder and to include the file name in the appended output as a column.
Remember that SharePoint is NOT a folding source so Incremental Refresh will not give any performance advantage.
Hi mp390988,
I wanted to check if you had the opportunity to review the information provided by lbendlin . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi mp390988,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi mp390988,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
