Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Extract records values into the cell

Hi

I'm extracing data from a sharepoint list, to a table.

 

Some of the column contains record-data, like:

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

The record in each row consist of the to row 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 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    hi, Anonymous 

    For your requirement, you may try this way:

    Step1:

    Expand the column contains record-data, now it will have multiple columns

    Step2:

    Select these columns, then right click the mouse and select merge column

    Now it will in one column

     

    Best Regards,
    Lin