Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.