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 are supposed to parse the JSON.
lbendlin could you please give a bit more information and context as I am new to doing this and learning as I go.
I tried adding a step in the DirectQuery to split the column by delimiter, but it will not let me do this unless the table is in import mode.
I also tried adding a new column with a SEARCH string, also not allowed in DirectAccess.