| <# 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. |
| dir -Filter *.csv | | |
| foreach { | |
| "$($_.Name)"; | |
| ,(Import-Csv -Path $_.Name) | | |
| Write-SqlTableData -ServerInstance localhost\SQL2017 -DatabaseName BlankDB -SchemaName dbo -TableName $_.BaseName -Force | |
| } |
| 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" | |
| } |
| <##################################################################################################> | |
| <# | |
| 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 | |
| $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 | |