Forum Discussion

lkshck's avatar
lkshck
Helper III
4 years ago
Solved

Azure Cost Management - Tags into two columns (TagName, TagValue)

Hey, I connected PowerBI to Azure Cost Management and I would like to split the current JSON structure into two columns which should contain TagName and TagValue. Currently I did it via the followin...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, lkshck 

    I don't think you need to have the column like = "{"&[Tags]&"}".

    You can try splitting column values as follows:

    1.Split selected column into multiple rows by delimiter 'Comma'

    2.Split selected column into columns by delimiter 'Colon'

    3.Replace quotation marks with empty values

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi， lkshck 

What roughly does your current JSON structure look like? Have you tried splitting column values according to some rules?

 

Best Regards,
Community Support Team _ Eason