@lt79_Pax wrote:
Since it can be incorporated into Power BI, does anyone know where I might find supporting documentation?
Are you saying that this can be incorporated directly into Power BI or just that it's possible to execute a T-SQL query including a json path?
If it's the second option then you'd need to look at the json path documentation for SQL Server as in that instance Power BI is just passing through the query for it to be processed by SQL Server. From what I can see in the documentation the $. references the current json object and the "name", "info", "text" represent nodes in the specific json object hierarchy and will change depending on the json structure that you are querying.
Is this the documentation that you were referring to https://docs.microsoft.com/en-us/sql/relational-databases/json/json-path-expressions-sql-server?view...?
Have you followed the links at the bottom in the "See Also" section as the docs for OPENJSON and JSON_QUERY have some more examples that might help.
Otherwise if you have a specific problem you are working on you could post a small example json snippet and let us know what data you are trying to extract.
