Forum Discussion

vinothkumar1990's avatar
vinothkumar1990
Helper II
3 years ago

JSON Parse in Direct Query mode

Hi All,

In one of the my SAP HANA database table colunns store the JSON format data and i want to decode them and show in the power bi report. Due to some reason and restriction from ogranization, i have to use the Direct query mode only. But JSON decode is not working in direct query mode. Any alternatve ways?

I tried with SAP HANA inbuild JSON function but not working properly.

 

Thanks,

VIinoth

Need Help

1 Reply

  • OleGr's avatar
    OleGr
    New Member
    2 years ago

    Hi Vlinoth,

     

    Did you found a solution to your problem? We've met the same obstacle.

     

    Hoping for a hint or more

    Thanks,

    Ole