Forum Discussion
Solved
Help splitting column in PowerBi DirectAccess
I am manipulating some data from a Log Analytics Workspace, the data is logs from Intune. One of the columns that is imported includes lots of information seperated by commars, semicolons etc. I wa...
You'll need to parse the JSON data in the column. This can be done in Power Query. Check this out https://learn.microsoft.com/en-us/power-query/parse-json-xml
I haven't done this for a while, but you should be able to add a column with the parsed json and then expand the column that you want.
You'll need to parse the JSON data in the column. This can be done in Power Query. Check this out https://learn.microsoft.com/en-us/power-query/parse-json-xml
I haven't done this for a while, but you should be able to add a column with the parsed json and then expand the column that you want.