Forum Discussion

nfontaine's avatar
nfontaine
Regular Visitor
8 years ago

Getting & Posting Datasets with the C# v2.0 SDK seems broken?

When I get a DataSet using the SDK I am getting back just the ID and the GroupID,  all of the important information like the tables, columns, rows etc.. are null

 

Capture.PNG 

When I go to post a DataSet using the SDK I get a Bad Request:

 

"{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"

The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.

Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"

 

It appears that while the SDK call demands I use the v2.0 Dataset, some validation is taking place on the other end that is expecting the v1 still. Any work arounds or plans to fix this?

 

Thanks.

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    nfontaine wrote:

    When I get a DataSet using the SDK I am getting back just the ID and the GroupID,  all of the important information like the tables, columns, rows etc.. are null

     

     

    When I go to post a DataSet using the SDK I get a Bad Request:

     

    "{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"

    The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.

    Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"

     

    It appears that while the SDK call demands I use the v2.0 Dataset, some validation is taking place on the other end that is expecting the v1 still. Any work arounds or plans to fix this?

     

    Thanks.


    nfontaine

    I doubt the nulls are just as expected, because when I call the REST API Get Dataset directly, it doesn't return any table/column information.

     

    To get the tables information, you can try below code. Note the dataset shall be created via REST API or a steaming dataset, expection will be raised if you try to get tables from a dataset which is published from Power BI desktop.

    var tables =  client.Datasets.GetTablesInGroup(groupId, datasetId);

    Even with above code, it doesn't return columns information, the REST API Get Tables documentation contains some issue as well, per my test.

    • rallen's avatar
      rallen
      New Member

      What about the fact that sending over a v2.0 DataSet object throws an error?  

      • rallen's avatar
        rallen
        New Member

         

        When I get a DataSet using the SDK I am getting back just the ID and the GroupID,  all of the important information like the tables, columns, rows etc.. are null

         

         

        When I go to post a DataSet using the SDK I get a Bad Request:

         

        "{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"

        The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.

        Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"

         

        It appears that while the SDK call demands I use the v2.0 Dataset, some validation is taking place on the other end that is expecting the v1 still.  Any work arounds or plans to fix this?

         

        Thanks.