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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
dragonus
Helper III
Helper III

Is there a way to add an excel sheet onto a pre-existing table?

So I have this table (call it Table1) where it has been formatted and converted into a long table.

 

I have this spreadsheet in Excel (call it SS1) where it is the same format from the original wide spreadsheet of Table1.

 

Was wondering if there's a way to append the data from SS1 onto Table1, applying all of its modifications made in Powerbi?

3 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @dragonus ,

 

On the query editor you can append several tables so this is possible you need to do the merge before the steps.

 

Assuming you have the following query:

  • Source - Table 1
  • Add columns
  • Change Format
  • Delete Columns
  • Rename columns
  • ...
  • Last Step

What you need to do is to redo your query like this:

 

  • Source - Table 1
  • New source - Excel file
  • Append Source with New Source
  • Add columns
  • Change Format
  • Delete Columns
  • Rename columns
  • ...
  • Last Step

 

The two bold steps are the ones that you need to do what I ussually do is one of two things:

  • Create the new connection to the excel file and disable the load and do the append to this new connection
  • Create the new connection and copy the source line (using advance editor) to the initial query and then make the append between the two step (source and new source) on the original query, then delete the connection I used for the copy+paste.

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

mhossain
Solution Sage
Solution Sage

@dragonus 

Try below steps in powerquery:

--Import 'SS1' into your PBI and name the table it lets say 'SS1'

--Go to 'Table1' (existing table in pbi), and in toolbar find append option, there you can either append 'SS1' to existing 'Table1' or you can create new 3rd table and append 'Table1' and 'SS1' data there.

 

Hope this helps.

 

 

View solution in original post

v-deddai1-msft
Community Support
Community Support

Hi @dragonus ,

 

Just import SS1 into Power BI, select the source step in the applied steps of Table1, and then perform the append operation and select the SS1.

 

Capture.PNG

 

Capture1.PNG

 

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

 

Best Regards,

Dedmon Dai

 

View solution in original post

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

Hi @dragonus ,

 

Just import SS1 into Power BI, select the source step in the applied steps of Table1, and then perform the append operation and select the SS1.

 

Capture.PNG

 

Capture1.PNG

 

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

 

Best Regards,

Dedmon Dai

 

mhossain
Solution Sage
Solution Sage

@dragonus 

Try below steps in powerquery:

--Import 'SS1' into your PBI and name the table it lets say 'SS1'

--Go to 'Table1' (existing table in pbi), and in toolbar find append option, there you can either append 'SS1' to existing 'Table1' or you can create new 3rd table and append 'Table1' and 'SS1' data there.

 

Hope this helps.

 

 

MFelix
Super User
Super User

Hi @dragonus ,

 

On the query editor you can append several tables so this is possible you need to do the merge before the steps.

 

Assuming you have the following query:

  • Source - Table 1
  • Add columns
  • Change Format
  • Delete Columns
  • Rename columns
  • ...
  • Last Step

What you need to do is to redo your query like this:

 

  • Source - Table 1
  • New source - Excel file
  • Append Source with New Source
  • Add columns
  • Change Format
  • Delete Columns
  • Rename columns
  • ...
  • Last Step

 

The two bold steps are the ones that you need to do what I ussually do is one of two things:

  • Create the new connection to the excel file and disable the load and do the append to this new connection
  • Create the new connection and copy the source line (using advance editor) to the initial query and then make the append between the two step (source and new source) on the original query, then delete the connection I used for the copy+paste.

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.