public Dashboard AddDashboard(string dashboardName, Guid workspaceId) { var requestBody = new AddDashboardRequest() { Name = dashboardName }; return(workspaceId.Equals(Guid.Empty) ? this.Client.Dashboards.AddDashboard(requestBody) : this.Client.Dashboards.AddDashboard(workspaceId.ToString(), requestBody)); }
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> /// Creates a new empty dashboard on **"My Workspace"**. /// </summary> /// <remarks> /// <br/>**Required scope**: Content.Create <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'> /// Add dashboard parameters /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <Dashboard> AddDashboardAsync(this IDashboardsOperations operations, AddDashboardRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.AddDashboardWithHttpMessagesAsync(requestParameters, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Creates a new empty dashboard on **"My Workspace"**. /// </summary> /// <remarks> /// <br/>**Required scope**: Content.Create <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'> /// Add dashboard parameters /// </param> public static Dashboard AddDashboard(this IDashboardsOperations operations, AddDashboardRequest requestParameters) { return(operations.AddDashboardAsync(requestParameters).GetAwaiter().GetResult()); }
/// <summary> /// Creates a new empty dashboard on the specified workspace. /// </summary> /// <remarks> /// <br/>**Required scope**: Content.Create <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'> /// Add dashboard parameters /// </param> public static Dashboard AddDashboardInGroup(this IDashboardsOperations operations, System.Guid groupId, AddDashboardRequest requestParameters) { return(operations.AddDashboardInGroupAsync(groupId, requestParameters).GetAwaiter().GetResult()); }