Forum Discussion

StefanKainz's avatar
StefanKainz
Frequent Visitor
2 years ago

Push Dataset create table API

Hello,   I've created a push dataset with two tables via API as documented here: Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn   Now I'd like to ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

delete all tables and then submit a single combined request to create the new table structures.  Then fill these new tables.

 

You may be trying to use push datasets in a way that they were not designed for. You may want to look at alternatives like streaming datasets.

StefanKainz's avatar
StefanKainz
Frequent Visitor
2 years ago

... submit a single combined request to create the new table structures

That is exactly my trouble. The question is: HOW to create the new table structures?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Like this

    https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset-in-group

     

     

    {
  "name": "Demo Export",
  "defaultMode": "Push",
  "tables": [
    { "name": "table1",
      "columns": [
        {
          "name": "Result",
          "dataType": "Int64"
        }
      ]
    },{ "name": "table2",
      "columns": [
        {
          "name": "fieldName",
          "dataType": "string"
        }
      ]
    },{ "name": "table3",
	  "columns": [
		{
		  "name": "ROWID",
		  "dataType": "string"
		}
	  ]
	}
  ]
}

     

    Looking at my notes it actually seems to be possible to add a table.

    https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-put-table-in-group

     

    {
"name": "table3",
"columns": [
{
"name": "ROWID",
"dataType": "string"
}
]
}

     

     

    • StefanKainz's avatar
      StefanKainz
      Frequent Visitor
      2 years ago

      Hello lbendlin,

      thank you once more for your reply.

       

      We cannot delete and recreate the whole dataset as explained. All depending reports and dashboard tiles would be gone too. So this is not an option.

       

      I tried to create a new table with https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-put-table-in-group, but got the following errormessage:

      {
    "error": {
        "code": "ItemNotFound",
        "message": "Table '<ccon>newTable</ccon>' not found in dataset 'sobe_wowvirtualserver|53ad1280-07a7-41dc-95cb-f5a283c199cb'"
    }
}

       

      Any further suggestions?

       

      BR Stefan

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago
        We cannot delete and recreate the whole dataset as explained

        Power BI datasets semantic models are ephemeral. You MUST be able and ready to recreate them at any time. Do not rely on Power BI for any sort of long term storage.

         

        Can you show the XMLA?

         

        (If you think about the effort you have already put in all of this - would it have been quicker to start from scratch?)