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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Unable to copy and paste the data into a new column in Power BI

Hi All,

 

Problem:

I have data in an Excel sheet(Unique ID) and I want to copy and paste this data into the existing table by creating a new column in power BI

 

Unique_ID(Excel sheet)

Sri1990_0-1686104414908.png

 

I want to create a new column here(UNIQUE_ID) and paste the above data into the newly created column:

Sri1990_1-1686104677729.png

 

Can someone please help me here?

 

Thank you

Kindest Regards

Sri

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Paste in Edit data. Then use List.Zip

 

Power BI Combine Tables Vertically(Row by Row). List.Zip -Power BI Combine Tables Vertically(Row by Row). List.Zip

 

How to Enter Data and Edit it-https://youtu.be/5nE7YGT72kU

Here you only need to paste

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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