无法使用RestApi获取Power Bi中的数据集列表？ [英] Unable to get list of datasets in power bi using RestApi?
问题描述
更新：看起来像您的令牌没有授予您获取数据集列表的权利。尝试注册一个新的本机应用程序，并确保选中数据集API中的读取所有数据集复选框。然后尝试使用以下代码获取访问令牌：
string redirectUri = https://login.live.com/ oauth20_desktop.srf；
string resourceUri = https://analysis.windows.net/powerbi/api;
string AuthorityUri = https://login.windows.net/common/oauth2/authorize;
string clientId = xxxxxx;
AuthenticationContext authContext = new AuthenticationContext（authorityUri，new TokenCache（））;
var authenticationResult =等待authContext.AcquireTokenAsync（resourceUri，clientId，new Uri（redirectUri），new PlatformParameters（PromptBehavior.Auto））;
if（authenticationResult！= null）
GetListOfDatasets（authenticationResult.AccessToken）;
更新：要使用Power BI Client库列出数据集，您需要这样的代码。首先，您需要使用AcquireTokenAsync（提供用户名和密码，或以交互方式提示）进行身份验证，然后将此访问令牌传递给客户端并调用GetDatasetsInGroupWithHttpMessageAsync方法。
私有静态字符串resourceUri = https://analysis.windows.net/powerbi/api;
私有静态字符串apiUrl = https://api.powerbi.com;
私有静态字符串clientId = xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;
私有静态字符串groupId = xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;
UserPasswordCredential uc = new UserPasswordCredential（ someuser@example.com，一些强密码）;
AuthenticationResult authenticationResult = authContext.AcquireTokenAsync（resourceUri，clientId，uc）.Result;
TokenCredentials凭据=新的TokenCredentials（$ {authenticationResult.AccessToken}， Bearer）;
使用（var client = new Microsoft.PowerBI.Api.V2.PowerBIClient（new Uri（apiUrl），凭据））
{
var resultDatasets =等待client.Datasets.GetDatasetsInGroupWithHttpMessagesAsync（groupId） ;
foreach（resultDatasets.Body.Value中的可变项）
MessageBox.Show（$ {item.Name}（{item.Id}））;
}
enter image description hereAfter getting Access token, by sending GET request to
https://app.powerbi.com/groups/me/datasets/
by adding access token in header
content-type: application/json authorization: access token
instead of getting datasets i am getting html content below:
> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" >
> <head>
> <title>Power BI</title>
> <meta http-equiv="X-UA-Compatible" content="IE=edge;" />
>
> <meta charset="utf-8">
> <meta name="description" content="">
> <meta name="format-detection" content="telephone=no" />
> <link rel="shortcut icon" href="/images/PowerBI_Favicon.ico" />
>
> <meta name="apple-itunes-app" content="app-id=929738808">
> <meta name="apple-itunes-app-tab" content="app-id=929738808">
> <meta name="google-play-app" content="app-id=com.microsoft.powerbim">
> <meta name="google-play-app-tab" content="app-id=com.microsoft.powerbim">
> <meta http-equiv="x-dns-prefetch-control" content="on"> .............
how to get list of datasets in json format?
code(java sdk):
String workspacename = "rightws";
String username = "xxxxxxxxxxx.onmicrosoft.com";
String workspaceId = "xxxxxxxxxxx1-9812b695603a";
String reportId="6xxxxxxxxxx4098-a55b-96f8c103edab";
String accessKey = "xxxxx34d7f7xxxxxxxxxxxx;
PowerBIToken token = PowerBIToken.CreateReportEmbedToken(
workspacename,
workspaceId,
reportId,
username,
null);
String jwt = token.Generate(accessKey);
System.out.println(jwt);
Try using this code:
var request = WebRequest.Create("https://api.powerbi.com/v1.0/myorg/datasets") as HttpWebRequest;
request.KeepAlive = true;
request.Method = "GET";
request.ContentLength = 0;
request.ContentType = "application/json";
request.Headers.Add("Authorization", $"Bearer {accessToken}");
using (HttpWebResponse httpResponse = request.GetResponse() as System.Net.HttpWebResponse)
{
using (StreamReader reader = new System.IO.StreamReader(httpResponse.GetResponseStream()))
{
string responseContent = reader.ReadToEnd();
MessageBox.Show(responseContent, "Get Datasets");
}
}
If you keep getting 403 error, then make sure you granted rights to read datasets when you register your application. Try to decode the access token at https://jwt.io and see does it contains Dataset.Read.All in scp:
UPDATE: It looks like your token doesn't give you rights to get the list of datasets. Try to register a new native application and make sure you select "Read All Datasets" checkbox from Dataset APIs. Then try to obtain the access token with code like this:
string redirectUri = "https://login.live.com/oauth20_desktop.srf";
string resourceUri = "https://analysis.windows.net/powerbi/api";
string authorityUri = "https://login.windows.net/common/oauth2/authorize";
string clientId = "xxxxxx";
AuthenticationContext authContext = new AuthenticationContext(authorityUri, new TokenCache());
var authenticationResult = await authContext.AcquireTokenAsync(resourceUri, clientId, new Uri(redirectUri), new PlatformParameters(PromptBehavior.Auto));
if (authenticationResult != null)
GetListOfDatasets(authenticationResult.AccessToken);
UPDATE: To list datasets using the Power BI Client library, you need code like this. First you need to authenticate using AcquireTokenAsync (either providing user name and password, or be prompted interactively), then pass this access token to your client and call GetDatasetsInGroupWithHttpMessageAsync method.
private static string resourceUri = "https://analysis.windows.net/powerbi/api";
private static string apiUrl = "https://api.powerbi.com";
private static string clientId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
private static string groupId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
UserPasswordCredential uc = new UserPasswordCredential("someuser@example.com", "some strong password");
AuthenticationResult authenticationResult = authContext.AcquireTokenAsync(resourceUri, clientId, uc).Result;
TokenCredentials credentials = new TokenCredentials($"{authenticationResult.AccessToken}", "Bearer");
using (var client = new Microsoft.PowerBI.Api.V2.PowerBIClient(new Uri(apiUrl), credentials))
{
var resultDatasets = await client.Datasets.GetDatasetsInGroupWithHttpMessagesAsync(groupId);
foreach (var item in resultDatasets.Body.Value)
MessageBox.Show($"{item.Name} ({item.Id})");
}
这篇关于无法使用RestApi获取Power Bi中的数据集列表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
