Simple PowerShell script to use the Google Search API to search for public Power BI reports

googlepbi.ps1

$apikey = ""
$baseUri = "https://www.googleapis.com/customsearch/v1"
$cx = ""
$query = "site:https://app.powerbi.com"


function GetSearchResults([string]$start)
{
$uri = "$($baseUri)?key=$($apikey)&cx=$($cx)&q=$($query)&start=$($start)"
$c = Invoke-WebRequest -Uri $uri -UseBasicParsing -Method Get
$results = $c.Content | ConvertFrom-Json
foreach ($result in $results.items)
{
    $reportUri = $($result.link)
    if ($reportUri.StartsWith("https://app.powerbi.com/view"))
    {
        Add-Content -Value $reportUri -Path "urls.csv"
    }
}
return $results.queries.nextPage.startIndex
}


[int]$counter = 0
while ($counter -le 1000)
{
    $counter = GetSearchResults($counter)
    Start-Sleep -Seconds 4
}