Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to create a dataSet from the PowerBi API with OData Url as datasource.
that request work perfectly but that create a AnalysisServices datasource:
{ "name":"SalesMarketing", "defaultMode":"AsOnPrem", "tables": [], "datasources":[ { "name":"SalesMarketing", "connectionString":"Data Source=asazure://westcentralus.asazure.windows.net/mypowerbi;Initial Catalog=SalesMarketing;Cube=Model" } ] }
that is an example of DataSet with odata source that i created manually and published it:
{ "@odata.context": "http://wabi-north-europe-redirect.analysis.windows.net/v1.0/myorg/$metadata#datasources", "value": [ { "datasourceType": "OData", "connectionDetails": { "url": "http://services.odata.org/V4/(S(cswa1ocrxydzpz0gfdqi5obb))/TripPinServiceRW" }, "datasourceId": "e2714955-d44f-4875-a618-be67d989746f", "gatewayId": "081e219f-bbe7-441c-bc63-b8e8875c984f" } ] }
I would like to know how to create a Odata datasource object in json for the API; tha connectionString ... ?
Solved! Go to Solution.
Hi @saifeddine,
If you want to create a dataset through API using OData as source, I'm afraid it isn't supported for now. Please refer to:
1. Problems-on-creating-a-new-dataset-with-Power-BI-s-REST-API
2. Create-a-Dataset-programatically
3. https://msdn.microsoft.com/library/mt203562.aspx.
>>>A Dataset also has a defaultMode property, which determines whether the dataset is pushed, streamed, or both, with values of "Push", "Streaming", "PushStreaming", "AzureAS" and "AsOnPrem". The default value is "Push".
The workaround could be retrieving data from OData source in your program and then pushing them into Power BI dataset.
Best Regards,
Dale
Hi @saifeddine,
If you want to create a dataset through API using OData as source, I'm afraid it isn't supported for now. Please refer to:
1. Problems-on-creating-a-new-dataset-with-Power-BI-s-REST-API
2. Create-a-Dataset-programatically
3. https://msdn.microsoft.com/library/mt203562.aspx.
>>>A Dataset also has a defaultMode property, which determines whether the dataset is pushed, streamed, or both, with values of "Push", "Streaming", "PushStreaming", "AzureAS" and "AsOnPrem". The default value is "Push".
The workaround could be retrieving data from OData source in your program and then pushing them into Power BI dataset.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |