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?
