Forum Discussion
Dataset.Tables is always null in Power BI for .NET v2
- 8 years ago
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).
Hi,
You can find it under the left menu > Workspaces>Datasets
Hi, cool! I found it.
But how can I change a dataset api access type? Is there a war to do that?