Create DataSet with Odata Source from API.

saifeddine — Tue, 29 May 2018 09:39:21 GMT

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 ... ?

Re: Create DataSet with Odata Source from API.

v-jiascu-msft — Wed, 30 May 2018 06:18:01 GMT

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

topic Re: Create DataSet with Odata Source from API. in Developer

Create DataSet with Odata Source from API.

Re: Create DataSet with Odata Source from API.