Forum Discussion
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
- lbendlinSuper User
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?
- tperzzNew 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.