Is it possible to convert the json object to column from any table in power bi?

[aishwarya08]

I have tried the cross apply open json in query but in direct query mode sql query is not able. so reply ASAP.

[v-xjiin-msft]

Hi @aishwarya08,

Since you are using direct query mode. I'm afraid that most of the solutions for parsing Json data may be unavailable in this mode. 

So I would still suggest you to do the open json at data source side. Maybe create a new table for this json data and you can simply call this new table at Power BI side with direct query mode.

Thanks,
Xi Jin.