Forum Discussion
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
Community 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