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);
}
