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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
moksha
Frequent Visitor

sync power bi table into excel automatically on monthly basis

I have a power bi file that has a table which gets updated monthly with new months data.

I would like to export the data month wise into excel sheets or workbooks on sharepoint whatever possible. Basically sync power bi table with excel on monthly basis keeping the previous data 

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @moksha ,

I still have a little confused about your requirement.

What's mean of "sync power bi table with excel on monthly basis keeping the previous data "?

If it is convenient, could you explain it in more details so that we can understand your scenario better?

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 A table keeps data per month , when current month is added the old  month's data gets overwritten. I want to show the old month data and new month data and keep appending it with new month's data.

Tables are retrieved from odata feed files so there is no way to know the sources of that tables.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors