/// <summary>
/// Create new group
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='requestParameters'>
/// Create group request parameters
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <Group> CreateGroupAsync(this IGroups operations, GroupCreationRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.CreateGroupWithHttpMessagesAsync(requestParameters, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
public async Task <Group> CreateAsync(string workspaceName)
{
using (var client = await _pbiService.GetPowerBIClient())
{
var groupRequest = new GroupCreationRequest(workspaceName);
var group = await client.Groups.CreateGroupAsync(groupRequest, workspaceV2 : true);
if (string.IsNullOrEmpty(_settings.UserEmail))
{
return(group);
}
try
{
var adminUser = new GroupUser()
{
GroupUserAccessRight = "Admin",
EmailAddress = _settings.UserEmail
};
await client.Groups.AddGroupUserAsync(group.Id, adminUser);
}
catch (Exception ex)
{
_logger.LogError($"Unable to add admin user to new workspace - {ex.Message}");
}
return(group);
}
}
static string CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = GetPowerBiClient();
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request, workspaceV2: true);
// return app workspace ID
return(aws.Id);
}
public string CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = this.GetPowerBiClient();
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request);
// return app workspace ID
return(aws.Id.ToString());
}
// testing operations
public static Guid CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = TokenManager.GetPowerBiClient(requiredScopes);
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request);
// return app workspace ID
return(aws.Id);
}
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);
}
public static async Task <Group> CreateGroupAsync(string workspaceName)
{
GroupCreationRequest request = null;
if (!string.IsNullOrEmpty(workspaceName))
{
request = new GroupCreationRequest(workspaceName);
}
using (PowerBIClient client = await CreateClient())
{
return(await client.Groups.CreateGroupAsync(request));
}
}
static void CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = GetPowerBiClient();
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request);
//GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", "SOME_USER.onMicrosoft.com");
//pbiClient.Groups.AddGroupUser(aws.Id, user1Permissions);
// member does not work yet - API is broken
//GroupUserAccessRight user2Permissions = new GroupUserAccessRight("Member", "*****@*****.**");
//pbiClient.Groups.AddGroupUser(aws.Id, user2Permissions);
}
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);
}
// testing operations
public static Guid CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = TokenManager.GetPowerBiAppOnlyClient();
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request);
pbiClient.Groups.AddGroupUser(aws.Id,
new GroupUser {
EmailAddress = "*****@*****.**",
GroupUserAccessRight = GroupUserAccessRight.Admin
});
// return app workspace ID
return(aws.Id);
}
public string CreateAppWorkspace(string Name)
{
PowerBIClient pbiClient = this.GetPowerBiClient();
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(Name);
Group aws = pbiClient.Groups.CreateGroup(request);
pbiClient.Groups.AddGroupUser(aws.Id, new GroupUser
{
EmailAddress = "*****@*****.**",
GroupUserAccessRight = "Admin"
});
// return app workspace ID
return(aws.Id.ToString());
}
public override async Task <GroupCreationResponse> CreateGroup(GroupCreationRequest request, ServerCallContext context)
{
UserGroup group = new UserGroup
{
Name = request.Name,
};
_authDbContext.Add(group);
await _authDbContext.SaveChangesAsync();
return(new GroupCreationResponse
{
GroupId = group.Id.ToString(),
Success = true,
});
}
/// <summary>
/// Creates new workspace.
/// </summary>
/// <remarks>
/// <br/>**Required scope**: 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'>
/// Create group request parameters
/// </param>
/// <param name='workspaceV2'>
/// Preview feature: Create a workspace V2. The only supported value is true.
/// </param>
public static Group CreateGroup(this IGroupsOperations operations, GroupCreationRequest requestParameters, bool?workspaceV2 = default(bool?))
{
return(operations.CreateGroupAsync(requestParameters, workspaceV2).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();
}
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);
Console.WriteLine();
GroupCreationRequest request = new GroupCreationRequest(targetAppWorkpaceName);
Group AppWorkspace = pbiClient.Groups.CreateGroup(request, workspaceV2: true);
targetAppWorkspaceId = AppWorkspace.Id;
}
var reports = pbiClient.Reports.GetReportsInGroup(sourceAppWorkspaceId).Value;
string downloadPath = @"C:\Student\downloads\";
// create download folder if it doesn't exist
if (!Directory.Exists(downloadPath))
{
Directory.CreateDirectory(downloadPath);
}
foreach (var report in reports)
{
var reportStream = pbiClient.Reports.ExportReportInGroup(sourceAppWorkspaceId, report.Id);
string filePath = downloadPath + 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 dashboard tile 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>
/// Create new group
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='requestParameters'>
/// Create group request parameters
/// </param>
public static Group CreateGroup(this IGroups operations, GroupCreationRequest requestParameters)
{
return(operations.CreateGroupAsync(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;
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();
}
}
public CreateGroupRequest(GroupCreationRequest GroupCreationRequest)
{
this.GroupCreationRequest = GroupCreationRequest;
}
/// <summary>
/// Create new group
/// </summary>
/// <param name='requestParameters'>
/// Create group request 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 <Group> > CreateGroupWithHttpMessagesAsync(GroupCreationRequest requestParameters, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken))
{
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("requestParameters", requestParameters);
tracingParameters.Add("cancellationToken", cancellationToken);
ServiceClientTracing.Enter(_invocationId, this, "CreateGroup", tracingParameters);
}
// Construct URL
var _baseUrl = Client.BaseUri.AbsoluteUri;
var _url = new System.Uri(new System.Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "v1.0/myorg/groups").ToString();
// 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 <Group>();
_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 <Group>(_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 Main(string[] args)
{
// Create client.
UserServicePortTypeClient client = new UserServicePortTypeClient();
/*
* CREATE USER
*/
UserCreationRequest userCreationRequest = new UserCreationRequest();
userCreationRequest.username = "******";
userCreationRequest.firstname = "Max";
userCreationRequest.lastname = "Mustermann";
userCreationRequest.gender = false;
userCreationRequest.age = "38";
UserCreationResponse userCreationResponse = client.CreateUser(userCreationRequest);
if (!userCreationResponse.response)
{
Console.WriteLine("ERROR : user creation request failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: user creation request succeeded");
}
/*
* CREATE GROUP
*/
GroupCreationRequest groupCreationRequest = new GroupCreationRequest();
groupCreationRequest.groupname = "testers";
GroupCreationResponse groupCreationResponse = client.CreateGroup(groupCreationRequest);
if (!groupCreationResponse.response)
{
Console.WriteLine("ERROR : group creation request failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: group creation request succeeded");
}
/*
* ADD USER TO GROUP
*/
GroupAddUserRequest groupAddUserRequest = new GroupAddUserRequest();
groupAddUserRequest.username = "******";
groupAddUserRequest.groupname = "testers";
GroupAddUserResponse groupAddUserResponse = client.GroupAddUser(groupAddUserRequest);
if (!groupAddUserResponse.response)
{
Console.WriteLine("ERROR : adding user to group failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: adding user to group succeeded");
}
/*
* GET USER INFO
*/
UserInfoRequest userInfoRequest = new UserInfoRequest();
userInfoRequest.username = "******";
UserInfo userInfoResponse = client.GetUserInfo(userInfoRequest);
if (userInfoResponse.firstname != "Max" ||
userInfoResponse.lastname != "Mustermann" ||
userInfoResponse.gender != false ||
userInfoResponse.age != "38")
{
Console.WriteLine("ERROR : getting user info failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: getting user info succeeded");
}
/*
* GET GROUP INFO
*/
GroupInfoRequest groupInfoRequest = new GroupInfoRequest();
groupInfoRequest.groupname = "testers";
string[] groupInfoResponse = client.GetGroupInfo(groupInfoRequest);
if (groupInfoResponse.Length != 1 ||
groupInfoResponse[0] != "user")
{
Console.WriteLine("ERROR : getting group info failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: getting group info succeeded");
}
/*
* REMOVE USER FROM GROUP
*/
GroupDeleteUserRequest groupDeleteUserRequest = new GroupDeleteUserRequest();
groupDeleteUserRequest.username = "******";
groupDeleteUserRequest.groupname = "testers";
GroupDeleteUserResponse groupDeleteUserResponse = client.GroupDeleteUser(groupDeleteUserRequest);
if (!groupDeleteUserResponse.response)
{
Console.WriteLine("ERROR : deleting user from group failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: deleting user from group succeeded");
}
/*
* DELETE USER
*/
UserDeletionRequest userDeletionRequest = new UserDeletionRequest();
userDeletionRequest.username = "******";
UserDeletionResponse userDeletionResponse = client.DeleteUser(userDeletionRequest);
if (!userDeletionResponse.response)
{
Console.WriteLine("ERROR : deleting user failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: deleting user succeeded");
}
/*
* DELETE GROUP
*/
GroupDeletionRequest groupDeletionRequest = new GroupDeletionRequest();
groupDeletionRequest.groupname = "testers";
GroupDeletionResponse groupDeletionResponse = client.DeleteGroup(groupDeletionRequest);
if (!groupDeletionResponse.response)
{
Console.WriteLine("ERROR : deleting group failed");
Console.ReadLine();
}
else
{
Console.WriteLine("SUCCESS: deleting group succeeded");
Console.ReadLine();
}
}
static void ClonePersonalWorkspaceInAppWorkspace(string AppWorkpaceName)
{
PowerBIClient pbiClient = GetPowerBiClient();
string AppWorkspaceId = "";
var workspaces = pbiClient.Groups.GetGroups().Value;
foreach (var workspace in workspaces)
{
if (workspace.Name.Equals(AppWorkpaceName))
{
AppWorkspaceId = workspace.Id;
}
}
if (AppWorkspaceId == "")
{
// create app workspace if it doesn't exist
Console.WriteLine("Creating app workspace named " + AppWorkpaceName);
GroupCreationRequest request = new GroupCreationRequest(AppWorkpaceName);
Group AppWorkspace = pbiClient.Groups.CreateGroup(request);
AppWorkspaceId = AppWorkspace.Id;
}
var reports = pbiClient.Reports.GetReports().Value;
foreach (var report in reports)
{
// create URL with pattern v1.0/myorg/reports/{report_id}/Export/
string restUrlDownloadExport =
urlPowerBiRestApiRoot + "v1.0/myorg/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:\Demos\" + 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 " + AppWorkpaceName);
var import = pbiClient.Imports.PostImportWithFileInGroup(AppWorkspaceId, stream, report.Name);
Console.WriteLine("Deleing file " + filePath);
File.Delete(filePath);
Console.WriteLine("Publishing process completed");
Console.WriteLine();
}
//GroupCreationRequest request = new GroupCreationRequest("AppWorkpaceName");
//Group aws = pbiClient.Groups.CreateGroup(request);
//GroupUserAccessRight user1Permissions = new GroupUserAccessRight("Admin", "*****@*****.**");
//pbiClient.Groups.AddGroupUser(aws.Id, user1Permissions);
//string targetWorkspaceId = aws.Id;
// member does not work yet - API is broken
//GroupUserAccessRight user2Permissions = new GroupUserAccessRight("Member", "*****@*****.**");
//pbiClient.Groups.AddGroupUser(aws.Id, user2Permissions);
}
public void InitTests()
{
_request1 = new AccountsCreationRequest()
{
CCName = "John Doe",
CCNumber = "4111111111111111",
CCExpMonth = 9,
CCExpYear = 2010,
CCType = "Mastercard",
Comments = "Testing comment",
CompanyBillAddress1 = "123 Any St",
CompanyBillAddress2 = "Suite 101",
CompanyBillCity = "Austin",
CompanyBillState = "TX",
CompanyBillZip = "78727",
CompanyName = "IWidgets Inc",
CompanyPhone = "512-555-5555",
CompanyPhyAddress1 = "5901 Physical Way",
CompanyPhyAddress2 = "Suite 11",
CompanyPhyCity = "Austin",
CompanyPhyState = "TX",
CompanyPhyZip = "78727",
HowHearAbout = 16,
LoginName = "Foobar",
RequesterFirstName = "John",
RequesterLastName = "Doe",
RequesterEmail = "*****@*****.**",
RequesterPhone = "(512) 555-5555",
UserPWD = "FOO",
CCOptOut = true
};
_search1 = new AccountsCreationRequest()
{
CCName = "charlotte POweLL",
CCNumber = "4111111111111111",
CCExpMonth = 9,
CCExpYear = 2010,
CCType = "Mastercard",
Comments = "Testing comment",
CompanyBillAddress1 = "5408 -A Bell Street",
CompanyBillAddress2 = "",
CompanyBillCity = "amarillo",
CompanyBillState = "TX",
CompanyBillZip = "79109",
CompanyName = "Great Nation INVEstment corp",
CompanyPhone = "8063536767",
CompanyPhyAddress1 = "5408 -A Bell Street",
CompanyPhyAddress2 = "",
CompanyPhyCity = "amarillo",
CompanyPhyState = "TX",
CompanyPhyZip = "79109",
HowHearAbout = 16,
LoginName = "Foobar",
RequesterFirstName = "CHarlotte",
RequesterLastName = "powell",
RequesterEmail = "*****@*****.**",
RequesterPhone = "5124487791",
UserPWD = "FOO"
};
_badSearch = new AccountsCreationRequest()
{
CCName = "YO MAMMA"
};
_request2 = new AccountsCreationRequest()
{
Comments = "Testing comment2",
CompanyBillAddress1 = "124 Any St",
CompanyBillAddress2 = "Suite 102",
CompanyBillCity = "Austin",
CompanyBillState = "TX",
CompanyBillZip = "78727-5170",
CompanyName = "IWidgets Inc",
CompanyPhone = "512-555-5555",
//CompanyPhone = "5125555555",
CompanyPhyAddress1 = "5902 Physical Way",
CompanyPhyAddress2 = "Suite 12",
CompanyPhyCity = "Austin",
CompanyPhyState = "TX",
CompanyPhyZip = "78727-5170",
HowHearAbout = 16,
LoginName = "Foobar2",
RequesterFirstName = "John2",
RequesterLastName = "Doe2",
RequesterEmail = "*****@*****.**",
RequesterPhone = "(512)-555-5555",
//RequesterPhone = "5125555555",
UserPWD = "FOO2",
CCExpMonth = 8,
CCName = "John A Holder",
CCNumber = "41111111111111",
CCExpYear = 2010,
CCType = "Visa",
VerificationCode = "556",
BillingZip = "78727-5170",
CCOptOut = true
};
_badRequest1 = new AccountsCreationRequest()
{
Comments = "Bad Testing comment2",
CompanyBillAddress1 = "124 Bad St",
CompanyBillAddress2 = "Suite BAD 102",
CompanyBillCity = "AustinBad",
CompanyBillState = "TX",
CompanyBillZip = "78727",
CompanyName = "IWidgets BAD Inc",
CompanyPhone = "512-555-5555",
//CompanyPhone = "5125555555",
CompanyPhyAddress1 = "5902 BAD Physical Way",
CompanyPhyAddress2 = "Suite BAD12",
CompanyPhyCity = "AustinBAD",
CompanyPhyState = "TX",
CompanyPhyZip = "78727",
HowHearAbout = 15,
LoginName = "Foobar2Bad",
RequesterFirstName = "John2Bad",
RequesterLastName = "Doe2Bad",
RequesterEmail = "*****@*****.**",
RequesterPhone = "1-(512)-555-5555",
UserPWD = "BAD It doesn;t accept a very long password to totally mess this up"
};
_goodRequest1 = new AccountsCreationRequest()
{
Comments = "GD Testing comment2",
CompanyBillAddress1 = "124 GD Any St",
CompanyBillAddress2 = "Suite GD102",
CompanyBillCity = "AustinGD",
CompanyBillState = "TX",
CompanyBillZip = "78727",
CompanyName = "IWidgets GDInc",
CompanyPhone = "512-555-5555",
//CompanyPhone = "5125555555",
CompanyPhyAddress1 = "5902 GDPhysical Way",
CompanyPhyAddress2 = "Suite GD12",
CompanyPhyCity = "AustinGD",
CompanyPhyState = "TX",
CompanyPhyZip = "78727",
HowHearAbout = 16,
LoginName = "Foobar2GD",
RequesterFirstName = "John2GD",
RequesterLastName = "Doe2GD",
RequesterEmail = "*****@*****.**",
RequesterPhone = "(512)-555-5555",
//RequesterPhone = "5125555555",
UserPWD = "GDFOO2"
};
_groupSearchUid = new GroupCreationRequest
{
UID = 1,
GroupDescr = "Test",
GroupName = "Test"
};
_groupSearchNoUid = new GroupCreationRequest
{
UID = -1,
GroupDescr = "Test",
GroupName = "Test"
};
_groupSearchUidBad = new GroupCreationRequest
{
UID = 1,
GroupDescr = "Test Im Not There",
GroupName = "Test Nor There"
};
}
