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.
2 Comments
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_ CaitlynYes 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
