Dataflow connected to Postgrade SQL db is not showing parse option

[chem094]

I have connected a Dataflow to Postgrad SQL DB, when I tried the parse option to expand the JSON type column. the parse option is not enabled in the transform tab.. when I change the column datatype to "text" then parse is enabled but that shows errors in future steps in the power query. 

[Anonymous]

Hi @chem094 ,

In Power Query, you can parse the contents of a column with text strings by identifying the contents as either a JSON or XML text string.

For more you may refer to 

Parse text as JSON or XML - Power Query | Microsoft Learn

Best regards.
Community Support Team_ Caitlyn

[chem094]

Yes but Dataflow is not identifying the contents for JSON expand when it has the column formatted as "Any" (ABC/123)..

if I change the column to text format then it shows a step error in the power query step with a red line indication.. thus when I connect it to PBI desktop the table shows empty.  Also, when I add new steps in power query in dataflow by adding merge columns, replace contents or etc. i am getting some red line error for those steps.. i wanted to complete all transformation steps in dataflow so that PBI desktop dont need those steps and can have better performance in refresh or for viewers