Forum Discussion

ksfx77's avatar
ksfx77
Icon for Helper I rankHelper I
5 years ago

Is it possible to pull values from a json blob using DAX?

Hi all,

 

I have a column containing a json blob, and I would like to create a calculated column to pull some values from the json.  Is this possible?

 

Everything I have seen suggest handling json can only be done in PQ?

 

Thanks

Kevin

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi ksfx77 

    I guess you could give it a go in DAX but it'll be much harder to manipulate the data than using PQ.  I'd be using PQ.

    Regards

    Phil

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi ksfx77 

    I don't think we can create a calculated column to pull data from the json as Power BI Desktop doesn't support this data type in the model. See data types in Power BI Desktop.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.