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

[hson89]

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");
}

[Eric_Zhang · Accepted solution]

---

@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]

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]

Hi,

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

[kelvinferreira]

Hi, cool! I found it.

But how can I change a dataset api access type? Is there a war to do that?

[hson89]

Thank you @Eric_Zhang. It wasn't a Push dataset or Hybrid. Thanks for your advice.