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.
