Forum Discussion
Auto Refresh from SharePoint folder
Hello all,
I have SahrePoint folder where are overnight genearted my AuditLogs.
How I should set up my file that Schedule Refresh will pick up new file and merge with exisitng dataset?
I know how to merge two csv files in PBI desktop but I don't know how to schedule that.
Many thanks in advance.
Andrej
Hi AndrejZitnay ,
"How I should set up my file that Schedule Refresh will pick up new file and merge with exisitng dataset?"
It's very easy to achieve, you just need to refresh the data.
First , I import and merge 3 files named "log1", "log2", "log3" with "SharePoint folder" connector.
Second, I upload "log4" file to SharePoint site and refresh all in "Edit Queries".
As you can see, when new files with the same structure are added to the SharePoint site, Power BI will automatically merge them for you when you refresh.
Also you can’t seem to connect to SharePoint, first, choose "File"-> “Options and settings” -> "Data source settings" -> "Clear Permissions" to clear the data source, then reconnect using the URL as mwegener said.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
