This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Variables | |
$TargetFolderName = "ProviderSolution" | |
$ProjectFilePath = "C:\temp\SSIS\TestSSISSolution\TestSSISProject\bin\Development\TestSSISProject.ispac" | |
$ProjectName = "TestSSISProject" | |
# Get the Integration Services catalog | |
$ProviderCatalog = Get-Item SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\ | |
# Create the target folder | |
New-Object "Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder" ($ProviderCatalog, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# This is the SSIS Project once it's deployed #> | |
$Proj = Get-Item 'SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\Folders\ProviderSolution\Projects\TestSSISProject' | |
$Proj | Get-Member -MemberType Methods | |
<# This is the theory I have #> | |
[byte[]] $ProjBytes = $Proj.GetProjectBytes() | |
[System.IO.File]::WriteAllBytes('C:\temp\ASSISPrj.ispac',$ProjBytes) | |
<# Dont run this piece of code, you will hate me. #> | |
$Proj.GetProjectBytes() |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Import-Module SqlServer; | |
cd $home\Documents\PoSh\Load\ | |
. .\Get-History2.ps1; | |
cd C:\temp; | |
<# First we need an argument completer for -ServerInstance #> | |
Register-ArgumentCompleter -ParameterName ServerInstance -ScriptBlock { | |
(dir -Recurse SQLSERVER:\SQLRegistration\'Database Engine Server Group'\ | | |
?{ $_.Mode -ne 'd'} | | |
Group-Object ServerName).Name | ForEach-Object { | |
$CompletionText = $_ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$source_workspace_ID = (Get-PowerBIWorkspace -Name 'QA-Workspace').Id | |
$report = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $source_workspace_ID | |
$target_workspace_ID = (Get-PowerBIWorkspace -Name 'Prod-Workspace').Id | |
$targetReport = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $target_workspace_ID | |
Copy-PowerBIReport -Report $report -WorkspaceId $source_workspace_ID -TargetWorkspaceId $target_workspace_ID -TargetDatasetId ($targetReport).DatasetId -OutVariable NewReport | |
<# Now to remove the old version of the report in the Prod workspace #> | |
#$url = 'https://api.powerbi.com/v1.0/myorg/groups/' + $target_workspace_ID + '/reports/' + $targetReport.Id | |
#Invoke-PowerBIRestMethod -Method Delete -Url $url |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# Clone Users from one Workspace to another | |
Start by specifying the Target Workspace | |
Then use the Out-GridView cmdlet to choose the Source Workspce to copy the users & roles from. | |
https://powerbi.microsoft.com/en-us/blog/announcing-apis-and-powershell-cmdlets-for-power-bi-administrators/ #> | |
$TargetWorkspace = Get-PowerBIWorkspace -Name 'New QA Workspace'; | |
(Get-PowerBIWorkspace | | |
Out-GridView -PassThru | | |
foreach { Get-PowerBIWorkspace -Id $_.Id -Scope Organization }).Users | | |
WHERE { $_.AccessRight -ne 'Viewer' } | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# We need an argument completer for -Workspace #> | |
Register-ArgumentCompleter -ParameterName Workspace -ScriptBlock { | |
Get-PowerBIWorkspace | ForEach-Object { | |
$CompletionText = $_.Name | |
New-Object System.Management.Automation.CompletionResult ( | |
"(Get-PowerBIWorkspace -Name '$($CompletionText)')", | |
$_.Name, | |
'ParameterValue', | |
"$_ (PowerBIWorkspace)" | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$UserCredential = Get-Credential 'your.email@somewhere.com' | |
90..1 | | |
foreach { | |
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection | |
Import-PSSession $Session | |
$Start=((Get-Date).Date).AddDays(-$_); | |
Search-UnifiedAuditLog -StartDate $Start -EndDate $Start.AddDays(1) -RecordType PowerBI -ResultSize 5000 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<##################################################################################################> | |
<# | |
Export information about assets in the Power BI Tenant to individual CSV files. | |
#> | |
<##################################################################################################> | |
<# | |
NOTE: You have to be a Power BI Admin to use the -Scope Organization parameter option. #> | |
<# First, get all the capacities for the tenant, if they have any #> | |
Get-PowerBICapacity -Scope Organization | |