Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"); }
Solved! Go to 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"); }
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).
@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).
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.
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?
Thank you @Eric_Zhang. It wasn't a Push dataset or Hybrid. Thanks for your advice.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |