Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Post Patron
6 years ago
Solved

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 kno...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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 Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.