cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dan_n Frequent Visitor
Frequent Visitor

Extract value from record directly into record cell itself

Hi

I'm extracting data from a sharepoint list, to a Power Bi table.

 

Some of the columns in my dataset contains record-data:

.... | ID | Column   | .... 
----------------------------
.... |  1  | Record  |.... 
.... |  2  | Record  |.... 
......

The record in consist of two row of data, with value:

------------------------------------
Description |  Link description    |
URL         |   Link URL           |
------------------------------------

I looking for at way to extract the value of the record, into the original table, without a "drill down" to a new table to the content of the record.

 

What I need is:

.... | ID | Column                     | .... 
---------------------------------------------
.... |  1  | Record .decription.value  |.... 
.... |  2  | Record .decription.value  |.... 
......

So my table end up looking like this:

.... | ID | Column                                   | .... 
-----------------------------------------------------------
.... |  1 | Link - description from record row ID 1  |.... 
.... |  2 | Link - description from record row ID 2  |.... 
......


How is that possible in PowerBI ? I would prefer not add another column, to keeping the values og the record.URL in the original cell.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Extract value from record directly into record cell itself

@dan_n ,

 

Just try using Table.ReplaceValue and Record.Field.

https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079

 

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Extract value from record directly into record cell itself

@dan_n ,

 

Just try using Table.ReplaceValue and Record.Field.

https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079

 

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.