PowerBiClient executequeries giving 'BadRequest' response.

Coder86 — Wed, 11 Oct 2023 05:02:22 GMT

Hi @Anonymous ,

I am calling powerBI rest APIs using C# with authentication. I can able to get datasets and groups using PowerBIClient class. While executing ExecuteQueryInGroup method gives me bad request error.

Below is the sample code to generate token and getting datasets and groups using PowerBIClient API class.

AuthenticationResult? authenticationResult = null;
IEnumerable<string> scopes = new string[] { "https://analysis.windows.net/powerbi/api/.default" };
var tenantSpecificUrl = "https://login.microsoftonline.com/tenent_Id/oauth2/token";

PublicClientApplication clientApp = PublicClientApplicationBuilder.Create("appId").
WithAuthority(tenantSpecificUrl).WithClientId("clientId").Build();
var userAccounts = clientApp.GetAccountsAsync().Result;
try
{
if (userAccounts == null)
{
authenticationResult = clientApp.AcquireTokenSilent(scopes, userAccounts?.FirstOrDefault()).ExecuteAsync().Result;
}
else
{
authenticationResult = clientApp.AcquireTokenByUsernamePassword(scopes, "username", "password").ExecuteAsync().Result;
}
}
catch (MsalUiRequiredException)
{

}
return authenticationResult.AccessToken;

Get Dataset and Use Below Code to ExecuteQueries

DatasetExecuteQueriesResponse datasetExecuteQueriesResponse =
client.Datasets.ExecuteQueriesInGroup(new Guid("xxxxx"),
"xxxxx", datasetDatasetExecuteQueriesRequest);

The above code give me error "Operation returned an invalid status code 'BadRequest'"

Can someone help what am I missing here?

Re: PowerBiClient executerqueries giving 'BadRequest' response.

Anonymous — Wed, 11 Oct 2023 00:46:48 GMT

Hi @Coder86 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

topic PowerBiClient executequeries giving 'BadRequest' response. in Developer

PowerBiClient executequeries giving 'BadRequest' response.

Re: PowerBiClient executerqueries giving 'BadRequest' response.