Forum Discussion
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"); }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_ZhangMicrosoft 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"); }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).
- hson89New Member
Thank you Eric_Zhang. It wasn't a Push dataset or Hybrid. Thanks for your advice.
- kelvinferreiraRegular 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.
- hson89New Member
Hi,
You can find it under the left menu > Workspaces>Datasets