cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors