Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Johann_32
Advocate II
Advocate II

Automatically detect new excel files in Sharepoint Folder and load them to semantic model

Hello,

 

we have a very specific request, in which users are storing several Excel Files (different file names, same amount of columns and same name of columns inside) per week in a sharepoint folder. This means, each of those files only differs in the rows.

 

Now, we know how we can merge multiple Excel files together in one table in Power BI Desktop, but this is not enough.

After the report is built and published, there should be a kind of mechanism to detect when again a new file was stored in that Sharepoint Folder, and that excel file should also be loaded into the semantic model to have newest data available in the report.

 

We know this is a very uncommon request, as data should be collected in one or several defined Excels, but still I would like to ask if somebody had that challenge in the past.

 

Thank you 

 

Johann

1 ACCEPTED SOLUTION

You're right. To add new files to the semantic model you need to save the files that have the same structure in the same folder and use "GetData" from Sharepoint Folder. You can learn about it in this video - link

View solution in original post

3 REPLIES 3
Sergii24
Super User
Super User

Hi @Johann_32, you can use Power Automate to obtain the desired result:

Sergii24_0-1711535306231.png


In the first step you can also detect any changes in the folder which will trigger the following actions. Delay is used to make sure that file has been properly uploaded to SharePoint and all sync has been finished. Then you refresh a semantic model. 

Have a great day! 

 

Thanks for the quick reply!

 

As far as I understand, this would help only for triggering the refresh. But it does not add completely new Excel files to the Report and Semantic Model, that have never been before in the report.

 

Or did I misunderstood?

You're right. To add new files to the semantic model you need to save the files that have the same structure in the same folder and use "GetData" from Sharepoint Folder. You can learn about it in this video - link

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.