Parsing JSON from a column to power bi with direct query mode

[mahendrakadam]

Hi All,

How can I parse JSON from a column with a direct query connectin (SQL server) in PowerBI and what if the coulmn numbers may not be same.

[danextian]

Hi @mahendrakadam ,

Although Power BI supports direct query connections for SQL, not all operations are available. Alternatively, you may use a script to query the database during the connection process.

A similar post was already made before: https://community.fabric.microsoft.com/t5/Power-Query/JSON-and-Direct-Query/td-p/343083