Forum Discussion
Auto Refresh from SharePoint folder
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.
Hi AndrejZitnay ,
import the SharePoint folder.
Maybe this helps.
https://www.youtube.com/watch?v=F6uqnwU9prU
Hello mwegener ,
that should work.
I am just fighting with right folder/libray.
I have created library for my AuditLogs but I can't access it.
I am able to access site and all files there but that not what I need to merge.
Can you advice what I am doing wrong?
Hi AndrejZitnay ,
I think you have to use the following format.
https://<<sharepoint site root url>>/sites/<<group name, sub site name or teams site name>>/
...
https://<<sharepoint site root url>>/sites/DataAnalystUnit/
