public async Task <HttpResponseMessage> GetTileEmbedToken() { var result = new TileEmbedConfig(); try { var error = GetWebConfigErrors(); if (error != null) { result.ErrorMessage = error; return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } // Create a user password cradentials. var credential = new UserPasswordCredential(Username, Password); // Authenticate using created credentials var authenticationContext = new AuthenticationContext(AuthorityUrl); var authenticationResult = await authenticationContext.AcquireTokenAsync(ResourceUrl, ApplicationId, credential); if (authenticationResult == null) { result.ErrorMessage = "Authentication Failed."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, 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)) { // Get a list of dashboards. var dashboards = await client.Dashboards.GetDashboardsInGroupAsync(WorkspaceId); // Get the first report in the workspace. var dashboard = dashboards.Value.FirstOrDefault(); if (dashboard == null) { result.ErrorMessage = "Workspace has no dashboards."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } var tiles = await client.Dashboards.GetTilesInGroupAsync(WorkspaceId, dashboard.Id); // Get the first tile in the workspace. var tile = tiles.Value.FirstOrDefault(); // Generate Embed Token for a tile. var generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view"); var tokenResponse = await client.Tiles.GenerateTokenInGroupAsync(WorkspaceId, dashboard.Id, tile.Id, generateTokenRequestParameters); if (tokenResponse == null) { result.ErrorMessage = "Failed to generate embed token."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } // Generate Embed Configuration. result.EmbedToken = tokenResponse; result.EmbedUrl = tile.EmbedUrl; result.Id = tile.Id; result.dashboardId = dashboard.Id; return(Request.CreateResponse(HttpStatusCode.OK, result)); } } catch (HttpOperationException exc) { result.ErrorMessage = string.Format("Status: {0} ({1})\r\nResponse: {2}\r\nRequestId: {3}", exc.Response.StatusCode, (int)exc.Response.StatusCode, exc.Response.Content, exc.Response.Headers["RequestId"].FirstOrDefault()); return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } catch (Exception exc) { result.ErrorMessage = exc.ToString(); return(this.Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } }
public async Task <HttpResponseMessage> GetReportEmbedToken(string username, string roles) { var result = new EmbedConfig(); try { result = new EmbedConfig { Username = username, Roles = roles }; var error = GetWebConfigErrors(); if (error != null) { result.ErrorMessage = error; return(this.Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } // Create a user password cradentials. var credential = new UserPasswordCredential(Username, Password); var newCredential = CredentialCache.DefaultCredentials; // Authenticate using created credentials var authenticationContext = new AuthenticationContext(AuthorityUrl); var authenticationResult = await authenticationContext.AcquireTokenAsync(ResourceUrl, ApplicationId, credential); if (authenticationResult == null) { result.ErrorMessage = "Authentication Failed."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, 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)) { // Get a list of reports. var reports = await client.Reports.GetReportsInGroupAsync(WorkspaceId); // No reports retrieved for the given workspace. if (reports.Value.Count() == 0) { result.ErrorMessage = "No reports were found in the workspace"; return(this.Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } Report report; if (string.IsNullOrWhiteSpace(ReportId)) { // Get the first report in the workspace. report = reports.Value.FirstOrDefault(); } else { report = reports.Value.FirstOrDefault(r => r.Id == ReportId); } if (report == null) { result.ErrorMessage = "No report with the given ID was found in the workspace. Make sure ReportId is valid."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } var datasets = await client.Datasets.GetDatasetByIdInGroupAsync(WorkspaceId, report.DatasetId); bool?IsEffectiveIdentityRequired = datasets.IsEffectiveIdentityRequired; bool?IsEffectiveIdentityRolesRequired = datasets.IsEffectiveIdentityRolesRequired; GenerateTokenRequest generateTokenRequestParameters; // This is how you create embed token with effective identities if (!string.IsNullOrWhiteSpace(username)) { var rls = new EffectiveIdentity(username, new List <string> { report.DatasetId }); if (!string.IsNullOrWhiteSpace(roles)) { var rolesList = new List <string>(); rolesList.AddRange(roles.Split(',')); rls.Roles = rolesList; } // Generate Embed Token with effective identities. generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view", identities: new List <EffectiveIdentity> { rls }); } else { // Generate Embed Token for reports without effective identities. generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view"); } var tokenResponse = await client.Reports.GenerateTokenInGroupAsync(WorkspaceId, report.Id, generateTokenRequestParameters); if (tokenResponse == null) { result.ErrorMessage = "Failed to generate embed token."; return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } // Generate Embed Configuration. result.EmbedToken = tokenResponse; result.EmbedUrl = report.EmbedUrl; result.Id = report.Id; return(Request.CreateResponse(HttpStatusCode.OK, result)); } } catch (HttpOperationException exc) { result.ErrorMessage = string.Format("Status: {0} ({1})\r\nResponse: {2}\r\nRequestId: {3}", exc.Response.StatusCode, (int)exc.Response.StatusCode, exc.Response.Content, exc.Response.Headers["RequestId"].FirstOrDefault()); return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } catch (Exception exc) { result.ErrorMessage = exc.ToString(); return(Request.CreateResponse(HttpStatusCode.InternalServerError, result)); } }
internal Task AcquireTokenAsync(string resourceUrl, string applicationId, UserPasswordCredential credential) { throw new NotImplementedException(); }