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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
wilsjohnc
Regular Visitor

Append data automatically

I have excel file generated daily basis. Need to get data from daily generated file automatically. Tried table.insertrows but its giving error. Is this correct function or any other way to do this. Please try to explain in detail.

1 REPLY 1
artemus
Microsoft Employee
Microsoft Employee

Normally every time you refresh the data set it load the entire data set again.

 

If you want to append two tables together you can:

 

Table1 & Table2

 

Or if you have a bunch of tables to append you can:

Table.Combine(listOfTables)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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