how to write schema this data in json format for post dataset in power bi rest api

[Anonymous]

 {

            "reportRefreshDate": "2022-02-25",

            "userPrincipalName": "xyz@gmail.com",

            "displayName": "xyz",

            "isDeleted": false,

            "deletedDate": null,

            "lastActivityDate": "2022-02-25",

            "sendCount": 0,

            "receiveCount": 3,

            "readCount": 3,

            "meetingCreatedCount": 0,

            "meetingInteractedCount": 0,

            "assignedProducts": [

                "MUSIC",

                "MICROSOFT "

            ],

            "reportPeriod": "7"

        },

I want to write a schema for creating a dataset  using the above data

[Anonymous]

Hi @Anonymous ,

I'm not clear about your needs. Are you using the REST API Push Datasets - Datasets PostDataset? And do you want to connect the call results (in JSON format) in Power BI? If so, maybe you can refer to the following documentation links to implement it.

Importing data from JSON files and Power BI Rest APIs into Power BI

Using Power BI with JSON Data Sources and Files

Best Regards

[Anonymous]

I am using Push dataset rest api  and i  am trying to post the above dataset schema

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can write the schema as follow and run the REST API Push Datasets - Datasets PostDataset to create the dataset first:

{
  "name": "Reportview",  //dataset name
  "defaultMode": "Push", 
  "tables": [
    {
      "name": "reporttrack", //table name
      "columns": [
        {
          "name": "reportRefreshDate",
          "dataType": "DateTime"
        },
        {
          "name": "userPrincipalName",
          "dataType": "string"
        },
        {
          "name": "displayName",
          "dataType": "string"
        },
        {
          "name": "isDeleted",
          "dataType": "bool"
        },
		 {
          "name": "deletedDate",
          "dataType": "DateTime"
        },
		 {
          "name": "lastActivityDate",
          "dataType": "DateTime"
        },
			 {
          "name": "sendCount",
          "dataType": "Int64"
        },
			 {
          "name": "receiveCount",
          "dataType": "Int64"
        },
			 {
          "name": "readCount",
          "dataType": "Int64"
        },
		  {
          "name": "meetingCreatedCount",
          "dataType": "Int64"
        },
		  {
          "name": "meetingInteractedCount",
          "dataType": "Int64"
        },
        {
          "name": "assignedProducts",
          "dataType": "string"
        },
        {
          "name": "reportPeriod",
          "dataType": "Int64"
        }
      ]
    }
  ]
}

Then run the REST API Push Datasets - Datasets PostRows using the below json data to add the rows into the table in above new created dataset.

{
  "rows": [
    {
      "reportRefreshDate": "2022-02-25",
            "userPrincipalName": "xyz@gmail.com",
            "displayName": "xyz",
            "isDeleted": false,
            "deletedDate": null,
            "lastActivityDate": "2022-02-25",
            "sendCount": 0,
            "receiveCount": 3,
            "readCount": 3,
            "meetingCreatedCount": 0,
            "meetingInteractedCount": 0,
            "assignedProducts": "MUSIC",
            "reportPeriod": "7"
    }, {
      "reportRefreshDate": "2022-02-25",
            "userPrincipalName": "xyz@gmail.com",
            "displayName": "xyz",
            "isDeleted": false,
            "deletedDate": null,
            "lastActivityDate": "2022-02-25",
            "sendCount": 0,
            "receiveCount": 3,
            "readCount": 3,
            "meetingCreatedCount": 0,
            "meetingInteractedCount": 0,
            "assignedProducts": "MICROSOFT"  ,
            "reportPeriod": "7"
    }
  ]
}

Best Regards

[lbendlin]

I am not aware of a "Post dataset"  API call.  What you list looks more like a table/partition.  Please explain what you are trying to accomplish. Do you mean Push datasets?