public static async Task <Group> CreateWorkspacesAsync(string WorkspaceName) { PowerBIClient pbiClient = GetPowerBiClient(); GroupCreationRequest createRequest = new GroupCreationRequest(WorkspaceName); var workspace = await pbiClient.Groups.CreateGroupAsync(createRequest); var secondaryAdmin = "*****@*****.**"; var userRights = new GroupUserAccessRight("Admin", secondaryAdmin); await pbiClient.Groups.AddGroupUserAsync(workspace.Id, userRights); return(workspace); }
static void CreateAppWorkspace(string Name) { PowerBIClient pbiClient = GetPowerBiClient(); GroupCreationRequest request = new GroupCreationRequest(Name); Group aws = pbiClient.Groups.CreateGroup(request); GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", masterUserAccount); pbiClient.Groups.AddGroupUser(aws.Id, user1Permissions); // string customersCapcityId = "CAPACITY_GUID"; // AssignToCapacityRequest capReq = new AssignToCapacityRequest(customersCapcityId); // pbiClient.Groups.AssignToCapacity(aws.Id, capReq); }
static void CreateAppWorkspace(string Name) { PowerBIClient pbiClient = GetPowerBiClient(); GroupCreationRequest request = new GroupCreationRequest(Name); Group aws = pbiClient.Groups.CreateGroup(request); GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", "*****@*****.**"); pbiClient.Groups.AddGroupUser(aws.Id, user1Permissions); string customersCapcityId = "C9CCAA3E-18FB-4F2E-930F-CD3ABF609B8A"; AssignToCapacityRequest capReq = new AssignToCapacityRequest(customersCapcityId); pbiClient.Groups.AssignToCapacity(aws.Id, capReq); }
static void CloneAppWorkspace(string sourceAppWorkspaceName, string targetAppWorkpaceName) { PowerBIClient pbiClient = GetPowerBiClient(); string sourceAppWorkspaceId = ""; string targetAppWorkspaceId = ""; var workspaces = pbiClient.Groups.GetGroups().Value; foreach (var workspace in workspaces) { if (workspace.Name.Equals(sourceAppWorkspaceName)) { sourceAppWorkspaceId = workspace.Id; } if (workspace.Name.Equals(targetAppWorkpaceName)) { targetAppWorkspaceId = workspace.Id; } } if (sourceAppWorkspaceId == "") { throw new ApplicationException("Source Workspace does not exist"); } if (targetAppWorkspaceId == "") { // create app workspace if it doesn't exist Console.WriteLine("Creating app workspace named " + targetAppWorkpaceName); GroupCreationRequest request = new GroupCreationRequest(targetAppWorkpaceName); Group AppWorkspace = pbiClient.Groups.CreateGroup(request); targetAppWorkspaceId = AppWorkspace.Id; string masterUserAccount = "*****@*****.**"; Console.WriteLine("Configuring " + masterUserAccount + " as workspace admin"); GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", masterUserAccount); pbiClient.Groups.AddGroupUser(targetAppWorkspaceId, user1Permissions); Console.WriteLine("Configuring workspace to run in dedicated capacity"); string customersCapcityId = "C9CCAA3E-18FB-4F2E-930F-CD3ABF609B8A"; AssignToCapacityRequest capReq = new AssignToCapacityRequest(customersCapcityId); pbiClient.Groups.AssignToCapacity(targetAppWorkspaceId, capReq); Console.WriteLine(); } var reports = pbiClient.Reports.GetReportsInGroup(sourceAppWorkspaceId).Value; foreach (var report in reports) { var reportStream = pbiClient.Reports.ExportReportInGroup(sourceAppWorkspaceId, report.Id); string filePath = @"C:\tempExport\" + report.Name + ".pbix"; Console.WriteLine("Downloading PBIX file for " + report.Name + "to " + filePath); FileStream stream1 = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite); reportStream.CopyToAsync(stream1).Wait(); reportStream.Close(); stream1.Close(); stream1.Dispose(); FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read); Console.WriteLine("Publishing " + filePath + " to " + targetAppWorkpaceName); var import = pbiClient.Imports.PostImportWithFileInGroup(targetAppWorkspaceId, stream, report.Name); Console.WriteLine("Deleing file " + filePath); stream.Close(); stream.Dispose(); File.Delete(filePath); Console.WriteLine(); } Console.WriteLine("Export/Import process completed"); var dashboards = pbiClient.Dashboards.GetDashboardsInGroup(sourceAppWorkspaceId).Value; foreach (var sourceDashboard in dashboards) { // create the target dashboard Console.WriteLine(); Console.WriteLine("Creating Dashboard named " + sourceDashboard.DisplayName); AddDashboardRequest addReq = new AddDashboardRequest(sourceDashboard.DisplayName); Dashboard targetDashboard = pbiClient.Dashboards.AddDashboardInGroup(targetAppWorkspaceId, addReq); // clone tiles IList <Tile> sourceTiles = pbiClient.Dashboards.GetTilesInGroup(sourceAppWorkspaceId, sourceDashboard.Id).Value; foreach (Tile sourceTile in sourceTiles) { Console.WriteLine("Adding title with title of " + sourceTile.Title); var sourceDatasetID = sourceTile.DatasetId; var sourceDatasetName = pbiClient.Datasets.GetDatasetByIdInGroup(sourceAppWorkspaceId, sourceDatasetID).Name; var targetWorkspaceDatasets = pbiClient.Datasets.GetDatasetsInGroup(targetAppWorkspaceId).Value; string targetDatasetId = ""; foreach (var ds in targetWorkspaceDatasets) { if (ds.Name.Equals(sourceDatasetName)) { targetDatasetId = ds.Id; } } if (targetDatasetId.Equals("")) { throw new ApplicationException("OOOOOuch!"); } var sourceReportId = sourceTile.ReportId; var sourceReportName = pbiClient.Reports.GetReportInGroup(sourceAppWorkspaceId, sourceReportId).Name; var targetWorkspaceReports = pbiClient.Reports.GetReportsInGroup(targetAppWorkspaceId).Value; string targetReportId = ""; foreach (var r in targetWorkspaceReports) { if (r.Name.Equals(sourceReportName)) { targetReportId = r.Id; } } CloneTileRequest addReqTile = new CloneTileRequest(targetDashboard.Id, targetAppWorkspaceId, targetReportId, targetDatasetId); pbiClient.Dashboards.CloneTileInGroup(sourceAppWorkspaceId, sourceDashboard.Id, sourceTile.Id, addReqTile); } } Console.WriteLine(); Console.WriteLine("All done - wow that was a lot of work :)"); Console.WriteLine(); }
/// <summary> /// Add a group user /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='groupId'> /// The group id /// </param> /// <param name='userDetails'> /// user access right details /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <object> AddGroupUserAsync(this IGroups operations, string groupId, GroupUserAccessRight userDetails, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.AddGroupUserWithHttpMessagesAsync(groupId, userDetails, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Add a group user /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='groupId'> /// The group id /// </param> /// <param name='userDetails'> /// user access right details /// </param> public static object AddGroupUser(this IGroups operations, string groupId, GroupUserAccessRight userDetails) { return(operations.AddGroupUserAsync(groupId, userDetails).GetAwaiter().GetResult()); }
/// <summary> /// Add a group user /// </summary> /// <param name='groupId'> /// The group id /// </param> /// <param name='userDetails'> /// user access right details /// </param> /// <param name='customHeaders'> /// Headers that will be added to request. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> /// <exception cref="HttpOperationException"> /// Thrown when the operation returned an invalid status code /// </exception> /// <exception cref="SerializationException"> /// Thrown when unable to deserialize the response /// </exception> /// <exception cref="ValidationException"> /// Thrown when a required parameter is null /// </exception> /// <exception cref="System.ArgumentNullException"> /// Thrown when a required parameter is null /// </exception> /// <return> /// A response object containing the response body and response headers. /// </return> public async Task <HttpOperationResponse <object> > AddGroupUserWithHttpMessagesAsync(string groupId, GroupUserAccessRight userDetails, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken)) { if (groupId == null) { throw new ValidationException(ValidationRules.CannotBeNull, "groupId"); } if (userDetails == null) { throw new ValidationException(ValidationRules.CannotBeNull, "userDetails"); } // Tracing bool _shouldTrace = ServiceClientTracing.IsEnabled; string _invocationId = null; if (_shouldTrace) { _invocationId = ServiceClientTracing.NextInvocationId.ToString(); Dictionary <string, object> tracingParameters = new Dictionary <string, object>(); tracingParameters.Add("groupId", groupId); tracingParameters.Add("userDetails", userDetails); tracingParameters.Add("cancellationToken", cancellationToken); ServiceClientTracing.Enter(_invocationId, this, "AddGroupUser", tracingParameters); } // Construct URL var _baseUrl = Client.BaseUri.AbsoluteUri; var _url = new System.Uri(new System.Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "v1.0/myorg/groups/{groupId}/users").ToString(); _url = _url.Replace("{groupId}", System.Uri.EscapeDataString(groupId)); // Create HTTP transport objects var _httpRequest = new HttpRequestMessage(); HttpResponseMessage _httpResponse = null; _httpRequest.Method = new HttpMethod("POST"); _httpRequest.RequestUri = new System.Uri(_url); // Set Headers if (customHeaders != null) { foreach (var _header in customHeaders) { if (_httpRequest.Headers.Contains(_header.Key)) { _httpRequest.Headers.Remove(_header.Key); } _httpRequest.Headers.TryAddWithoutValidation(_header.Key, _header.Value); } } // Serialize Request string _requestContent = null; if (userDetails != null) { _requestContent = Rest.Serialization.SafeJsonConvert.SerializeObject(userDetails, Client.SerializationSettings); _httpRequest.Content = new StringContent(_requestContent, System.Text.Encoding.UTF8); _httpRequest.Content.Headers.ContentType = System.Net.Http.Headers.MediaTypeHeaderValue.Parse("application/json; charset=utf-8"); } // Set Credentials if (Client.Credentials != null) { cancellationToken.ThrowIfCancellationRequested(); await Client.Credentials.ProcessHttpRequestAsync(_httpRequest, cancellationToken).ConfigureAwait(false); } // Send Request if (_shouldTrace) { ServiceClientTracing.SendRequest(_invocationId, _httpRequest); } cancellationToken.ThrowIfCancellationRequested(); _httpResponse = await Client.HttpClient.SendAsync(_httpRequest, cancellationToken).ConfigureAwait(false); if (_shouldTrace) { ServiceClientTracing.ReceiveResponse(_invocationId, _httpResponse); } HttpStatusCode _statusCode = _httpResponse.StatusCode; cancellationToken.ThrowIfCancellationRequested(); string _responseContent = null; if ((int)_statusCode != 200) { var ex = new HttpOperationException(string.Format("Operation returned an invalid status code '{0}'", _statusCode)); if (_httpResponse.Content != null) { _responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false); } else { _responseContent = string.Empty; } ex.Request = new HttpRequestMessageWrapper(_httpRequest, _requestContent); ex.Response = new HttpResponseMessageWrapper(_httpResponse, _responseContent); if (_shouldTrace) { ServiceClientTracing.Error(_invocationId, ex); } _httpRequest.Dispose(); if (_httpResponse != null) { _httpResponse.Dispose(); } throw ex; } // Create Result var _result = new HttpOperationResponse <object>(); _result.Request = _httpRequest; _result.Response = _httpResponse; // Deserialize Response if ((int)_statusCode == 200) { _responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false); try { _result.Body = Rest.Serialization.SafeJsonConvert.DeserializeObject <object>(_responseContent, Client.DeserializationSettings); } catch (JsonException ex) { _httpRequest.Dispose(); if (_httpResponse != null) { _httpResponse.Dispose(); } throw new SerializationException("Unable to deserialize the response.", _responseContent, ex); } } if (_shouldTrace) { ServiceClientTracing.Exit(_invocationId, _result); } return(_result); }
static void CloneAppWorkspace(string sourceAppWorkspaceName, string targetAppWorkpaceName) { PowerBIClient pbiClient = GetPowerBiClient(); string sourceAppWorkspaceId = ""; string targetAppWorkspaceId = ""; var workspaces = pbiClient.Groups.GetGroups().Value; foreach (var workspace in workspaces) { if (workspace.Name.Equals(sourceAppWorkspaceName)) { sourceAppWorkspaceId = workspace.Id; } if (workspace.Name.Equals(targetAppWorkpaceName)) { targetAppWorkspaceId = workspace.Id; } } if (sourceAppWorkspaceId == "") { throw new ApplicationException("Source Workspace does not exist"); } if (targetAppWorkspaceId == "") { // create app workspace if it doesn't exist Console.WriteLine("Creating app workspace named " + targetAppWorkpaceName); GroupCreationRequest request = new GroupCreationRequest(targetAppWorkpaceName); Group AppWorkspace = pbiClient.Groups.CreateGroup(request); targetAppWorkspaceId = AppWorkspace.Id; GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", "*****@*****.**"); pbiClient.Groups.AddGroupUser(targetAppWorkspaceId, user1Permissions); } var reports = pbiClient.Reports.GetReportsInGroup(sourceAppWorkspaceId).Value; foreach (var report in reports) { // create URL with pattern v1.0/myorg/{workspace_id}/reports/{report_id}/Export/ string restUrlDownloadExport = urlPowerBiRestApiRoot + "v1.0/myorg/groups/" + sourceAppWorkspaceId + "/reports/" + report.Id + "/Export/"; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Accept", "application/json"); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + GetAccessToken()); // send PATCH request to Power BI service HttpResponseMessage response = client.GetAsync(restUrlDownloadExport).Result; string filePath = @"C:\temp\" + report.Name + ".pbix"; Console.WriteLine("Downloading PBIX file for " + report.Name + "to " + filePath); FileStream stream1 = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite); response.Content.CopyToAsync(stream1).Wait(); stream1.Close(); stream1.Dispose(); FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read); Console.WriteLine("Publishing " + filePath + " to " + targetAppWorkpaceName); var import = pbiClient.Imports.PostImportWithFileInGroup(targetAppWorkspaceId, stream, report.Name); Console.WriteLine("Deleing file " + filePath); File.Delete(filePath); Console.WriteLine("Publishing process completed"); Console.WriteLine(); } }