After split column : This query contains transformations that cannot be used in DirectQuery

[SzymonKl]

Hello All 

   I hope you're well.

This is the message I get: "This query contains transformations that can't be used for DirectQuery" when I try to split the information in a table using the "Split Column" function. I understand that this is due to the fact that it is DirectQuery. is there another way to separate this information, such as copying the column and formatting the copied one? Here is an example: the info is located in one column named ChangedFields:

{"state": "washed_pending", "updated_at": "2022-02-03 16:56:33", "base_type_id": "38", "asset_type_id": "37", "asset_quantity": "100"}

like to split :

The column name "state":

"washed_pending"

The column name "updated_at":

2022-02-03 16:56:33

The column name "base_type_id":

38

The column name "asset_type_id":

37

The column name "asset_quantity":

100

Can you please help me with this?

[SzymonKl]

Hi @lbendlin, The fields are always the same

[lbendlin]

Are these field names always the same and always present, or is that meta data dynamic?