Forum Discussion

tperzz's avatar
tperzz
New Member
4 years ago

How to create a dataset with datasource using API call

I have tried this https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset
but only able to create dataset with tables but not datasource.
Getting error:
{
"error": {
"code": "InvalidRequest",
"message": "TOM deserialization failed for database sobe_wowvirtualserver|, Exception: <pi>Unrecognized JSON property: datasources. Check path 'datasources', line 1, position 6112.</pi>"
}
}

2 Replies

  • In my experience Push datasets don't even support multiple tables. There's only a single table "RealTimeData"  that is created for you. All you can do is specify column names and types.  

     

    There is not really a data source either - you just push rows.

     

    What kind of streaming dataset are you trying to create?

    • tperzz's avatar
      tperzz
      New Member

      I am able to push multiple tables in a single dataset.

      I am using streaming mode as Push  "defaultMode": "Push"

      Still not able to create datasources along with dataset, on the contrary the API states that it can.