Forum Discussion
Rest: Extract a List which contains Records
Hello, I'm currently working with REST as datasource for a small project. That's the rest result: "customfield_1": [
{
"self": "https",
"value": "Dev",
...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi Jonas_Jonas,
To transfer data structure from
customfield_1: "Dev"
customfield_1: "Project"
customfield_1: "Care"
to
customfield_1: "Dev; Project; Care"
You can use pivot and unpivot featrure in Power BI. Turning columns to rows, or rows to columns is easy with Power Query and Power BI. Here is a document which describes basic pivot and unpivot in Power BI.
http://radacad.com/pivot-and-unpivot-with-power-bi
Regards,
Charlie Liao
Hi,
i added some information to the problem description
Best regards.
Jonas_Jonas