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

topic Getting & Posting Datasets with the C# v2.0 SDK seems broken? in Developer https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309062#M9220 <P> </P><P>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</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/70863i7046BC2EB087AE4D/image-size/large?v=v2&px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P> </P><P>When I go to post a DataSet using the SDK I get a Bad Request:</P><P> </P><P>"{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"</P><P><EM><STRONG>The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.</STRONG></EM></P><P>Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"</P><P> </P><P>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?</P><P> </P><P>Thanks.</P> Wed, 22 Nov 2017 18:05:15 GMT rallen 2017-11-22T18:05:15Z Getting & Posting Datasets with the C# v2.0 SDK seems broken? https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309128#M9115 <P>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</P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-one-column lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-24 lia-quilt-column-single lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-single"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV class="first-message"><DIV class="lia-message-view message-uid-309062"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="lia-effect-highlight lia-panel-message-root lia-message-board lia-panel-message lia-js-data-messageUid-309062"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message-custom"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><P> </P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper"><IMG title="Capture.PNG" alt="Capture.PNG" src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/70863i7046BC2EB087AE4D/image-size/large?v=1.0&px=600" border="0" /><SPAN class="lia-messages-message-image"> </SPAN></SPAN></SPAN></P><P>When I go to post a DataSet using the SDK I get a Bad Request:</P><P> </P><P>"{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"</P><P><EM><STRONG>The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.</STRONG></EM></P><P>Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"</P><P> </P><P>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?</P><P> </P><P>Thanks.</P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV> Wed, 22 Nov 2017 19:53:25 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309128#M9115 nfontaine 2017-11-22T19:53:25Z Getting & Posting Datasets with the C# v2.0 SDK seems broken? https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309062#M9220 <P> </P><P>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</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/70863i7046BC2EB087AE4D/image-size/large?v=v2&px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P> </P><P>When I go to post a DataSet using the SDK I get a Bad Request:</P><P> </P><P>"{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"</P><P><EM><STRONG>The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.</STRONG></EM></P><P>Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"</P><P> </P><P>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?</P><P> </P><P>Thanks.</P> Wed, 22 Nov 2017 18:05:15 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309062#M9220 rallen 2017-11-22T18:05:15Z Re: Getting & Posting Datasets with the C# v2.0 SDK seems broken? https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309465#M9135 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/33548">@nfontaine</a> wrote:<BR /> <P>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</P> <DIV class="lia-page"><CENTER> <DIV class="MinimumWidthContainer"> <DIV class="min-width-wrapper"> <DIV class="min-width"> <DIV class="lia-content"> <DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-one-column lia-top-quilt"> <DIV class="lia-quilt-row lia-quilt-row-main"> <DIV class="lia-quilt-column lia-quilt-column-24 lia-quilt-column-single lia-quilt-column-main-content"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-single"> <DIV class="lia-component-message-list"> <DIV class="linear-message-list message-list"> <DIV class="lia-linear-display-message-view"> <DIV class="first-message"> <DIV class="lia-message-view message-uid-309062"> <DIV> <DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"> <DIV> <DIV class="lia-effect-highlight lia-panel-message-root lia-message-board lia-panel-message lia-js-data-messageUid-309062"> <DIV class="lia-panel-message-content"> <DIV class="lia-decoration-border"> <DIV class="lia-decoration-border-content"> <DIV> <DIV> <DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message-custom"> <DIV class="lia-quilt-row lia-quilt-row-forum-message-main"> <DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"> <DIV class="lia-message-body"> <DIV class="lia-message-body-content"> <P> </P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/70863i7046BC2EB087AE4D/image-size/large?v=v2&px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span><SPAN class="lia-messages-message-image"> </SPAN></SPAN></SPAN></P> <P>When I go to post a DataSet using the SDK I get a Bad Request:</P> <P> </P> <P>"{\"error\":{\"code\":\"BadRequest\",\"message\":\"Bad Request\",\"details\":[{\"message\":\"</P> <P><EM><STRONG>The property 'IsRefreshable' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'.</STRONG></EM></P> <P>Make sure to only use property names that are defined by the type.\",\"target\":\"dataset\"}]}}"</P> <P> </P> <P>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?</P> <P> </P> <P>Thanks.</P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </CENTER></DIV> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/33548">@nfontaine</a></P> <P>I doubt the nulls are just as expected, because when I call the REST API <A href="https://msdn.microsoft.com/en-US/library/mt784653.aspx" target="_self">Get Dataset</A> directly, it doesn't return any table/column information.</P> <P> </P> <P>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.</P> <PRE>var tables = client.Datasets.GetTablesInGroup(groupId, datasetId);</PRE> <P>Even with above code, it doesn't return columns information, the REST API <A href="https://msdn.microsoft.com/en-us/library/mt203556.aspx" target="_self">Get Tables</A> documentation contains some issue as well, per my test.</P> Thu, 23 Nov 2017 07:43:37 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/309465#M9135 Eric_Zhang 2017-11-23T07:43:37Z Re: Getting & Posting Datasets with the C# v2.0 SDK seems broken? https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/311706#M9205 <P>What about the fact that sending over a v2.0 DataSet object throws an error?  </P> Mon, 27 Nov 2017 15:17:43 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-amp-Posting-Datasets-with-the-C-v2-0-SDK-seems-broken/m-p/311706#M9205 rallen 2017-11-27T15:17:43Z