JSON Parse in Direct Query mode

[vinothkumar1990]

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

[OleGr]

Hi Vlinoth,

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

Hoping for a hint or more

Thanks,

Ole