Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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>"
}
}
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?
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.
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 11 | |
| 10 | |
| 9 |
| User | Count |
|---|---|
| 43 | |
| 35 | |
| 23 | |
| 15 | |
| 14 |