Reply
Member
Posts: 61
Registered: ‎07-06-2018
Accepted Solution

If I merge two columns from an expanded field can I delete the unmerged columns?

So I have imported a SharePoint list into Power BI and there are some name lookup columns. I have expanded these to First Name and Surname columns, then merged them into one column.

The Query has retained the two unmerged columns, but I don't really want them. If I delete them, and new entries are added to the sharepoint list, will PowerBI know to pull through the same data in the format I have specified, or will it kick off?

 

Thanks :-)

 

Jemma


Accepted Solutions
Super User
Posts: 629
Registered: ‎04-02-2017

Re: If I merge two columns from an expanded field can I delete the unmerged columns?

@heytherejem If you have done all these steps in "Power Query" then it will have a list of steps that was performed on the data after imported. So if there is any new data (after refresh) then it will apply the same steps again. You no need to do all these again.



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

Proud to be a Datanaut!




View solution in original post


All Replies
Super User
Posts: 629
Registered: ‎04-02-2017

Re: If I merge two columns from an expanded field can I delete the unmerged columns?

@heytherejem If you have done all these steps in "Power Query" then it will have a list of steps that was performed on the data after imported. So if there is any new data (after refresh) then it will apply the same steps again. You no need to do all these again.



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

Proud to be a Datanaut!