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); }
/// <summary> /// Assigns the specified workspace to the specified capacity. /// </summary> /// <remarks> /// **Note**: To perform this operation, the user must be admin on the /// specified workspace and have admin or assign permissions on the capacity. /// To unassign the specified workspace from a capacity, Empty Guid /// (00000000-0000-0000-0000-000000000000) should be provided as capacityId. /// <br/><br/>**Required scope**: Capacity.ReadWrite.All and /// Workspace.ReadWrite.All <br/>To set the permissions scope, see /// [Register an /// app](https://docs.microsoft.com/power-bi/developer/register-app). /// </remarks> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='groupId'> /// The workspace id /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task AssignToCapacityAsync(this IGroupsOperations operations, System.Guid groupId, AssignToCapacityRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken)) { (await operations.AssignToCapacityWithHttpMessagesAsync(groupId, requestParameters, null, cancellationToken).ConfigureAwait(false)).Dispose(); }
/// <summary> /// Assigns the specified workspace to the specified capacity. /// </summary> /// <remarks> /// **Note**: To perform this operation, the user must be admin on the /// specified workspace and have admin or assign permissions on the capacity. /// To unassign the specified workspace from a capacity, Empty Guid /// (00000000-0000-0000-0000-000000000000) should be provided as capacityId. /// <br/><br/>**Required scope**: Capacity.ReadWrite.All and /// Workspace.ReadWrite.All <br/>To set the permissions scope, see /// [Register an /// app](https://docs.microsoft.com/power-bi/developer/register-app). /// </remarks> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='groupId'> /// The workspace id /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> public static void AssignToCapacity(this IGroupsOperations operations, System.Guid groupId, AssignToCapacityRequest requestParameters) { operations.AssignToCapacityAsync(groupId, requestParameters).GetAwaiter().GetResult(); }
/// <summary> /// Assigns **"My Workspace"** to the specified capacity. /// </summary> /// <remarks> /// **Note**: To perform this operation, the user must have admin or assign /// permissions on the capacity. To unassign **"My Workspace"** from a /// capacity, Empty Guid (00000000-0000-0000-0000-000000000000) should be /// provided as capacityId. <br/><br/>**Required scope**: /// Capacity.ReadWrite.All and Workspace.ReadWrite.All <br/>To set the /// permissions scope, see [Register an /// app](https://docs.microsoft.com/power-bi/developer/register-app). /// </remarks> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> public static void AssignMyWorkspaceToCapacity(this IGroupsOperations operations, AssignToCapacityRequest requestParameters) { operations.AssignMyWorkspaceToCapacityAsync(requestParameters).GetAwaiter().GetResult(); }
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> /// Assign My Workspace to a capacity /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <object> AssignMyWorkspaceToCapacityAsync(this IGroups operations, AssignToCapacityRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.AssignMyWorkspaceToCapacityWithHttpMessagesAsync(requestParameters, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Assign My Workspace to a capacity /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> public static object AssignMyWorkspaceToCapacity(this IGroups operations, AssignToCapacityRequest requestParameters) { return(operations.AssignMyWorkspaceToCapacityAsync(requestParameters).GetAwaiter().GetResult()); }
/// <summary> /// Assign a group to a capacity /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='groupId'> /// The group id /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </param> public static object AssignToCapacity(this IGroups operations, string groupId, AssignToCapacityRequest requestParameters) { return(operations.AssignToCapacityAsync(groupId, requestParameters).GetAwaiter().GetResult()); }
/// <summary> /// Assign a group to a capacity /// </summary> /// <param name='groupId'> /// The group id /// </param> /// <param name='requestParameters'> /// Assign to capacity parameters /// </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> > AssignToCapacityWithHttpMessagesAsync(string groupId, AssignToCapacityRequest requestParameters, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken)) { if (groupId == null) { throw new ValidationException(ValidationRules.CannotBeNull, "groupId"); } if (requestParameters == null) { throw new ValidationException(ValidationRules.CannotBeNull, "requestParameters"); } // 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("requestParameters", requestParameters); tracingParameters.Add("cancellationToken", cancellationToken); ServiceClientTracing.Enter(_invocationId, this, "AssignToCapacity", tracingParameters); } // Construct URL var _baseUrl = Client.BaseUri.AbsoluteUri; var _url = new System.Uri(new System.Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "v1.0/myorg/groups/{groupId}/AssignToCapacity").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 (requestParameters != null) { _requestContent = Rest.Serialization.SafeJsonConvert.SerializeObject(requestParameters, 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); }