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

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

hson89 — Mon, 23 Oct 2017 23:43:57 GMT

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

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

Eric_Zhang — Mon, 30 Oct 2017 09:16:55 GMT

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

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

hson89 — Mon, 30 Oct 2017 14:13:17 GMT

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

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

kelvinferreira — Thu, 25 Jan 2018 13:19:56 GMT

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.

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

hson89 — Fri, 26 Jan 2018 02:27:17 GMT

Hi,

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

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

kelvinferreira — Fri, 26 Jan 2018 11:15:10 GMT

Hi, cool! I found it.

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