it’s possible read a column with a json data file into PowerBI dataset and have it automatically parse out the JSON data into additional columns? Yes it’s possible! how?

it’s simple with power bi  and in particular with Power query:

In the query editor, right-click on the column that contains the JSON, go to Transform and select JSON. It will parse out the data, allowing you to add them in as additional column

Extremely handy!