TOJSON

TOJSON is a DAX function that converts the records of a table into a JSON text format.

Syntax

TOJSON(
   Table,
   MaxRows
)

Argument	Properties	Description
Table		The table to be converted.
MaxRows	Optional	The maximum number of rows to be converted. A negative number means all rows are converted. Default is 10.

Return Values

A string with JSON representation of the table. The representation contains column names as “header”, count-of-rows as “rowCount”, and values as “data”.

The following DAX query:

EVALUATE
{TOJSON(DimSalesTerritory)}

Returns:

{
"header": ["'DimSalesTerritory'[SalesTerritoryKey]", "'DimSalesTerritory'[SalesTerritoryAlternateKey]", "'DimSalesTerritory'[SalesTerritoryRegion]", "'DimSalesTerritory'[SalesTerritoryCountry]", "'DimSalesTerritory'[SalesTerritoryGroup]"],<br>
"rowCount": 11,
"data": [
[1, 1, "Northwest", "United States", "North America"],
[2, 2, "Northeast", "United States", "North America"],
[3, 3, "Central", "United States", "North America"],
[4, 4, "Southwest", "United States", "North America"],
[5, 5, "Southeast", "United States", "North America"],
[6, 6, "Canada", "Canada", "North America"],
[7, 7, "France", "France", "Europe"],
[8, 8, "Germany", "Germany", "Europe"],
[9, 9, "Australia", "Australia", "Pacific"],
[10, 10, "United Kingdom", "United Kingdom", "Europe"]
]
}

Related functions

Other functions related to TOJSON are:

• TOCSV

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/tojson-function-dax