Powerbi External Data Restricted

πŸ’Ό Management Samenvatting

Deze security regelen waarborgt de correcte configuratie van beveiligingsinstellingen op Windows endpoints.

Aanbeveling
IMPLEMENT
Risico zonder
High
Risk Score
7/10
Implementatie
2u (tech: 1u)
Van toepassing op:
βœ“ Windows

Deze instelling is onderdeel van de Windows security baseline en beschermt tegen bekende aanvalsvectoren door het afdwingen van veilige configuraties.

PowerShell Modules Vereist
Primary API: Graph
Connection: Connect-MgGraph
Required Modules: Microsoft.Graph.DeviceManagement

Implementatie

Dit regelen configureert powerbi external data restricted via Microsoft Intune apparaat configuratie beleid of compliance policies om Windows endpoints te beveiligen volgens security best practices.

Vereisten

m365

Implementatie

Gebruik PowerShell-script powerbi-external-data-restricted.ps1 (functie Invoke-Monitoring) – Monitoren.

monitoring

Gebruik PowerShell-script powerbi-external-data-restricted.ps1 (functie Invoke-Monitoring) – Controleren.

Remediatie

Gebruik PowerShell-script powerbi-external-data-restricted.ps1 (functie Invoke-Remediation) – Herstellen.

Compliance en Auditing

Beleid documentatie

Compliance & Frameworks

Automation

Gebruik het onderstaande PowerShell script om deze security control te monitoren en te implementeren. Het script bevat functies voor zowel monitoring (-Monitoring) als remediation (-Remediation).

PowerShell
<# .SYNOPSIS PowerBI External Data Restricted .DESCRIPTION Restricts external data export from PowerBI to prevent data leakage .NOTES NL Baseline v2.0 Manual configuration required in PowerBI Admin Portal #> #Requires -Version 5.1 #Requires -Modules MicrosoftPowerBIMgmt [CmdletBinding()] param([switch]$Monitoring) $ErrorActionPreference = 'Stop' Write-Host "`n========================================" -ForegroundColor Cyan Write-Host "PowerBI External Data Restricted" -ForegroundColor Cyan Write-Host "========================================`n" -ForegroundColor Cyan function Invoke-Monitoring { try { Write-Host " ⚠️ Manual verification required" -ForegroundColor Yellow Write-Host "`n Configuration in PowerBI Admin Portal:" -ForegroundColor Cyan Write-Host " 1. Go to PowerBI Admin Portal > Tenant settings" -ForegroundColor Gray Write-Host " 2. Export and sharing settings" -ForegroundColor Gray Write-Host " 3. Configure the following:" -ForegroundColor Gray Write-Host "`n Required Settings:" -ForegroundColor Cyan Write-Host " βœ“ Export data to Excel: Disabled for non-admins" -ForegroundColor Gray Write-Host " βœ“ Export data to .csv: Disabled for non-admins" -ForegroundColor Gray Write-Host " βœ“ Export reports as PowerPoint/PDF: Restricted" -ForegroundColor Gray Write-Host " βœ“ Export reports as images: Restricted" -ForegroundColor Gray Write-Host "`n Security Benefits:" -ForegroundColor Cyan Write-Host " β€’ Prevents data extraction" -ForegroundColor Gray Write-Host " β€’ Maintains data governance" -ForegroundColor Gray Write-Host " β€’ Reduces data leakage risk" -ForegroundColor Gray Write-Host "`n ⚠️ Note: Use PowerBI REST API for automation" -ForegroundColor Yellow Write-Host " Install-Module -Name MicrosoftPowerBIMgmt" -ForegroundColor Gray exit 0 } catch { Write-Host "ERROR: $_" -ForegroundColor Red exit 2 } } try { if ($Monitoring) { Invoke-Monitoring } else { Write-Host "Use: -Monitoring" -ForegroundColor Yellow } } catch { throw } finally { Write-Host "`n========================================`n" -ForegroundColor Cyan } function Invoke-Remediation { <# .SYNOPSIS Herstelt de configuratie naar de gewenste staat .DESCRIPTION Dit is een monitoring-only control, remediation delegeert naar monitoring #> [CmdletBinding()] param() Write-Host "[INFO] Dit is een monitoring-only control" -ForegroundColor Yellow Write-Host "[INFO] Running monitoring check..." -ForegroundColor Cyan Invoke-Monitoring }

Risico zonder implementatie

Risico zonder implementatie
High: No auth tracking.

Management Samenvatting

Schakel in audit logging.