Reply
JessseZ
New Member

Automating Weekly Excel Data Updates in Power BI

Hello, I am a new Power BI user. Every week, I receive an Excel file from our tool inventory system, which is saved in a local folder on our server. This file serves as the data source for a Power BI report that I manually update and publish to make it accessible to specific individuals.

The Excel file's content changes weekly, but the layout remains consistent. What I would like to achieve is the following: when the file is generated and uploaded to the local folder on Monday morning, it is automatically sent to, for example, SharePoint (or another platform). From there, I want to create a flow to enable Power BI to automatically update the report. How can i do this?

 

I tried something with power automate but they dont seem to work.

 

I would love to hear your tips or possible alternatives!

1 ACCEPTED SOLUTION

Hi, @JessseZ 

It is possible that you need to import the entire SharePoint folder. Here I take the local folder as an example:

vjianpengmsft_0-1734681024247.png

At first I only had two excels:

vjianpengmsft_1-1734681111250.png

vjianpengmsft_2-1734681150608.png

vjianpengmsft_3-1734681167900.png

vjianpengmsft_4-1734681205366.png

vjianpengmsft_5-1734681239930.png

vjianpengmsft_6-1734681287880.png

vjianpengmsft_7-1734681303564.png

vjianpengmsft_8-1734681327699.png

vjianpengmsft_10-1734681375223.png

vjianpengmsft_11-1734681401403.png

vjianpengmsft_12-1734681414415.png

Now let's test if my data will be updated automatically if I add a new excel:

vjianpengmsft_13-1734681595403.png

vjianpengmsft_14-1734681621856.png

vjianpengmsft_15-1734681640645.png

You can follow the steps above, apply it to the Sharepoint folder, and then configure a scheduled refresh for your semantic model.
Whenever you have a new structure with the same excel, they will automatically update the data.

 

 

Best Regards

Jianpeng Li

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

 

 

 

 

 

 

 

View solution in original post

5 REPLIES 5
v-jianpeng-msft
Community Support
Community Support

Thank you lbendlin 

Hi, @JessseZ 

I think you can use a file from OneDrive or SharePoint Online to build your report, then publish it in Power BI Service, and configure OneDrive refresh. Whenever your file data is updated, this will update the data in Power BI:

Refresh a Power BI Desktop File (pbix file) from OneDrive or SharePoint Online - Power BI | Microsof...

vjianpengmsft_0-1734663438399.png

Data refresh in Power BI - Power BI | Microsoft Learn

vjianpengmsft_1-1734663485653.png

 

 

Best Regards

Jianpeng Li

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

 

 

Hi Jianpeng, 

 

Yes, but I first need to set up an automatic upload from our local folder to OneDrive or SharePoint. The data in the Excel file itself doesn’t change, but a completely new Excel file with updated data is added each time. Therefore, the file path or name needs to automatically update to reflect the most recently added file.

Hi, @JessseZ 

It is possible that you need to import the entire SharePoint folder. Here I take the local folder as an example:

vjianpengmsft_0-1734681024247.png

At first I only had two excels:

vjianpengmsft_1-1734681111250.png

vjianpengmsft_2-1734681150608.png

vjianpengmsft_3-1734681167900.png

vjianpengmsft_4-1734681205366.png

vjianpengmsft_5-1734681239930.png

vjianpengmsft_6-1734681287880.png

vjianpengmsft_7-1734681303564.png

vjianpengmsft_8-1734681327699.png

vjianpengmsft_10-1734681375223.png

vjianpengmsft_11-1734681401403.png

vjianpengmsft_12-1734681414415.png

Now let's test if my data will be updated automatically if I add a new excel:

vjianpengmsft_13-1734681595403.png

vjianpengmsft_14-1734681621856.png

vjianpengmsft_15-1734681640645.png

You can follow the steps above, apply it to the Sharepoint folder, and then configure a scheduled refresh for your semantic model.
Whenever you have a new structure with the same excel, they will automatically update the data.

 

 

Best Regards

Jianpeng Li

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

 

 

 

 

 

 

 

lbendlin
Super User
Super User

Every week, I receive an Excel file from our tool inventory system

How do you receive the file?  Via email attachment?

Hi Ibendlin,

 

The file is exported directly to a designated folder on our server, without the use of email.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)