Forum Discussion

toafk's avatar
toafk
Frequent Visitor
5 years ago
Solved

XML data containing Tables and values

I'm using XML data as input to Power Bi.    This column "PiccoloConfig.Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.CustomPro.2" contains "Table" and Values. Theese are the val...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi toafk ,

    I see in your other thread opened here you already have the answer to your question (ImkeF's solution): 

     

    Table.TransformColumns(YourPreviousStep, {{“YourColumn”, each if Value.Is(_, type table) then _ else #table({“YourColumn”}, {{_}} ) }} )

     

     I believe the confusion comes from applying this step to your Source and not your previous step (#"Renamed Columns").

    Please confirm.

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi toafk ,

I see in your other thread opened here you already have the answer to your question (ImkeF's solution): 

 

Table.TransformColumns(YourPreviousStep, {{“YourColumn”, each if Value.Is(_, type table) then _ else #table({“YourColumn”}, {{_}} ) }} )

 

 I believe the confusion comes from applying this step to your Source and not your previous step (#"Renamed Columns").

Please confirm.