Extracting Data From A Table Using KVP (Key Value Pairs)

[SachinC]

Hi,
Using PowerBI to get some data.
The data has fields:

-----
Fieldname: Source
Value: Exterior
-----
Fieldname: Exterior.01.DefectNumber
Value: 1
-----
Fieldname: Exterior.01.FormattedCost
Value: 44
------
Fieldname: Exterior.02.DefectNumber
Value: 2
-----
Fieldname: Exterior.02.FormattedCost
Value: 88

I want to get this data and put into a PowerBI table view:

Defect# Cost
-----------------
1 44
2 88
etc...

How do I do this please? I think I need a DAX query.

Thanks!

 

[SachinC]

For a bit more info, I need to transpose the data into PowerBI - i.e. flat data in the SQL table --> PowerBI.

Here is an example from the table (copy/paste) to give you guys an idea of the format:

Id rowversion AutoID Inspection Report Source Key Value
7764142A-547E-4CFB-81C0-000003CBD2D5 0x00000000008B79F0 4134331 7447F735-9064-48B8-9B54-4B263FCB42A9 7447F735-9064-48B8-9B54-4B263FCB42A9 InspectionExterior InspectionExterior.04.DMM.Condition Chipped
E7286F5F-3658-4A3D-B8AF-00000436E362 0x00000000005D1698 2864055 87118D1E-EA1A-4907-B4C4-4806E832499E 87118D1E-EA1A-4907-B4C4-4806E832499E LooseItemsList LooseItemsList.ListItems MasterKey,WheelKey,SatNav,Literature,Handbook,Servicebook
B7E7E0BE-1CEF-4C86-9B03-0000084A5030 0x00000000001019D8 206751 9A71EF71-5F87-4B03-B17A-9652952E05EA 9A71EF71-5F87-4B03-B17A-9652952E05EA InspectionExterior InspectionExterior.06.Y 1040.97
1CA516B3-0245-4EF2-B7F3-000014053BEA 0x0000000000101C7D 824931 1116051D-B2CE-4CC7-A49F-F4CEB8CA4506 1116051D-B2CE-4CC7-A49F-F4CEB8CA4506 InspectionExterior InspectionExterior.04.DMM.SubArea Wing rear
2B4108DC-B3E4-466B-9D03-000016788964 0x00000000002ACD33 1446039 76012C91-EB17-4FF5-A877-D7B78E3AD734 76012C91-EB17-4FF5-A877-D7B78E3AD734 InspectionExterior InspectionExterior.08.Components Door front Van o/s,Door shut o/s/f,Door front apeture seal o/s,Door front check strap o/s,Door front decal o/s,Door handle outer front o/s,Door lock barrel front o/s,Door skin front o/s