SQLvariant

<# Make sure you have the modules installed.
     You only need the ImportExcel module if you want to export the results to Excel files. #>
Install-Module DataGateway
Install-Module ImportExcel

<# Discovery #>
# All Gateway Clusters in your tenant.
Get-DataGatewayCluster -Scope Organization

# All nodes of all Gateway Clusters in your tenant.

SQLvariant

dir -Filter *.csv |
foreach {

"$($_.Name)";

,(Import-Csv -Path $_.Name) | 
Write-SqlTableData -ServerInstance localhost\SQL2017 -DatabaseName BlankDB -SchemaName dbo -TableName $_.BaseName -Force

    }

SQLvariant

90..1 |
foreach {
    $Date = (((Get-Date).Date).AddDays(-$_))
    $StartDate = (Get-Date -Date ($Date) -Format yyyy-MM-ddTHH:mm:ss)
    $EndDate = (Get-Date -Date ((($Date).AddDays(1)).AddMilliseconds(-1)) -Format yyyy-MM-ddTHH:mm:ss)
    
    Get-PowerBIActivityEvent -StartDateTime $StartDate -EndDateTime $EndDate -ResultType JsonString | 
    Out-File -FilePath "c:\temp\PowerBIAuditLogs\PowerBI_AudititLog_$(Get-Date -Date $Date -Format yyyyMMdd).json"
}

SQLvariant

Use with Registered Servers

Use Registered Servers or Central Management Server to run Invoke-SqlNotebook against multiple servers.

$datetime = Get-Date -Format yyyyMMddhhmm

dir 'SQLSERVER:\SQLRegistration\Database Engine Server Group' |
WHERE { $_.Mode -ne 'd'} |            
foreach {

SQLvariant

<##################################################################################################>
<#
    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 | 

SQLvariant

$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 |

SQLvariant

<# 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)"
                )

SQLvariant

<# 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' } |

SQLvariant

$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

SQLvariant

Import-Module SqlServer;
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 = $_
    New-Object System.Management.Automation.CompletionResult (
              $CompletionText,