Forum Discussion

hson89's avatar
hson89
New Member
8 years ago
Solved

Dataset.Tables is always null in Power BI for .NET v2

Hi everyone,

 

I'm trying to get the access to the tables inside a dataset. I managed to get access to the dataset however the when I use dataset.Tables it always returns null. I also tried to use Datasets.GetTables and passed my dataset ID however it returned "Operation returned an invalid status code 'NotFound'" while with the same Dataset ID, I can get the dataset successfully. I'm using Microsoft.PowerBI.Api.V2 and developing on a Windows App. Can someone help to point out what I am missing here please? Below is my code

 

var credential = new UserPasswordCredential(Username, Password);

// Authenticate using created credentials
var authenticationContext = new AuthenticationContext(AuthorityUrl);
var authenticationResult = authenticationContext.AcquireTokenAsync(ResourceUrl, ClientId, credential).Result;

var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");

// Create a Power BI Client object (it will be used to call Power BI APIs)
using (var client = new PowerBIClient(new Uri(ApiUrl), tokenCredentials))
{
	var dataset = client.Datasets.GetDatasetByIdAsync("My dataset id");
}

 


  • hson89 wrote:

    Hi everyone,

     

    I'm trying to get the access to the tables inside a dataset. I managed to get access to the dataset however the when I use dataset.Tables it always returns null. I also tried to use Datasets.GetTables and passed my dataset ID however it returned "Operation returned an invalid status code 'NotFound'" while with the same Dataset ID, I can get the dataset successfully. I'm using Microsoft.PowerBI.Api.V2 and developing on a Windows App. Can someone help to point out what I am missing here please? Below is my code

     

    var credential = new UserPasswordCredential(Username, Password);
    
    // Authenticate using created credentials
    var authenticationContext = new AuthenticationContext(AuthorityUrl);
    var authenticationResult = authenticationContext.AcquireTokenAsync(ResourceUrl, ClientId, credential).Result;
    
    var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");
    
    // Create a Power BI Client object (it will be used to call Power BI APIs)
    using (var client = new PowerBIClient(new Uri(ApiUrl), tokenCredentials))
    {
    	var dataset = client.Datasets.GetDatasetByIdAsync("My dataset id");
    }

     


    hson89

    What type is the dataset? The underlying REST API Get Tables only supports  push datasets and hybrid datasets(streaming dataset with historic data analysis enabled).

     

5 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    hson89 wrote:

    Hi everyone,

     

    I'm trying to get the access to the tables inside a dataset. I managed to get access to the dataset however the when I use dataset.Tables it always returns null. I also tried to use Datasets.GetTables and passed my dataset ID however it returned "Operation returned an invalid status code 'NotFound'" while with the same Dataset ID, I can get the dataset successfully. I'm using Microsoft.PowerBI.Api.V2 and developing on a Windows App. Can someone help to point out what I am missing here please? Below is my code

     

    var credential = new UserPasswordCredential(Username, Password);
    
    // Authenticate using created credentials
    var authenticationContext = new AuthenticationContext(AuthorityUrl);
    var authenticationResult = authenticationContext.AcquireTokenAsync(ResourceUrl, ClientId, credential).Result;
    
    var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");
    
    // Create a Power BI Client object (it will be used to call Power BI APIs)
    using (var client = new PowerBIClient(new Uri(ApiUrl), tokenCredentials))
    {
    	var dataset = client.Datasets.GetDatasetByIdAsync("My dataset id");
    }

     


    hson89

    What type is the dataset? The underlying REST API Get Tables only supports  push datasets and hybrid datasets(streaming dataset with historic data analysis enabled).

     

    • kelvinferreira's avatar
      kelvinferreira
      Regular Visitor

      Hello.

      Where is this screen on the powerBI platform? I am new on this service and I don't know where is the option to change this.

      • hson89's avatar
        hson89
        New Member

        Hi,

         

        You can find it under the left menu > Workspaces>Datasets