Informes de descarga des power bi services
I need to download a report which has 3 pages as image and is published to power bi service and store that download in a local folder. I have the following code, but it gives me an authentication canceled error, notice that it has all the permissions in the power bi service and also in the application. Código en .ps1 # Variables de configuración $clientId = " " $tenantId = " " $workspaceId = " " $reportIds = @(" ") # Lista de ID de los informes que deseas descargar $outputPath = "C:\Users\ASUS\Documents\ ImgMob" $logFilePath = "C:\Users\ASUS\Documents\ImgMob\PowerBI_Logs.txt" # Credenciales codificadas $nombredeusuario = " " $contraseña = " " # Función para escribir en el log function Write-Log { param ( [string]$message ) $timestamp = Get-Date -Format "yyyy-MM-dd HH:mm:ss" $logMessage = "$timestamp - $message" Salida de escritura $logMessage $logMessage | Archivo de salida -FilePath $logFilePath -Append -Encoding utf8 } # Autenticación # Autenticación Write-Log "Iniciando proceso de autenticacion" try { $response = Invoke-RestMethod -Method Post -Uri "https://login.microsoftonline.com/$tenantId/oauth2/v2.0/token" -ContentType "application/x-www-form-urlencoded" -Body @{ grant_type = "password" client_id = $clientId scope = "https://graph.microsoft.com/.default" username = $username password = $password } $token = $response.access_token Write-Log "Autenticacion exitosa" } catch { $exceptionMessage = $_.Exception.Message if ($_.Exception.InnerException) { $innerExceptionMessage = $_.Exception.InnerException.Message Write-Log "Error en la autenticacion: $exceptionMessage Detalles adicionales: $innerExceptionMessage" } else { Write-Log "Error en la autenticacion: $exceptionMessage" } exit } # Función para descargar una página del informe como imagen function Download-ReportPageImage { param ( [string]$reportId, [string]$pageName ) $outputFile = Join-Path $outputPath "Informe_${reportId}_${pageName}_$(Get-Date -Format 'yyyyMMddHHmmss').png" $uri = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/reports/$reportId/pages/$pageName/exports/image" try { $response = Invoke-RestMethod -Method Get -Uri $uri -Headers @{ Authorization = "Bearer $token" } # Verificar si la respuesta tiene la imagen if ($response.image) { [System.IO.File]::WriteAllBytes($outputFile, [Convert]::FromBase64String($response.image)) Write-Log "Pagina ${pageName} del informe ${reportId} descargada y guardada en ${outputFile}" } else { Write-Log "La respuesta del servidor no contiene una imagen. Informe ${reportId}, página ${pageName}." } } catch { Write-Log "Error al descargar la pagina ${pageName} del informe ${reportId}: $($_.Exception.Message)" } } # Función para obtener las páginas del informe function Get-ReportPages { param ( [string]$reportId ) $uri = " https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/reports/$reportId/pages " prueba { $response = Invoke-RestMethod -Method Get -Uri $uri -Headers @ { Authorization = "Bearer $token" } if ($response.value) { Write-Log "Paginas del informe ${reportId} obtenidas exitosamente" return $response.value } else { Write-Log "El servidor no devolvió ninguna página para el informe ${reportId}" return @() } } catch { Write-Log "Error al obtener las paginas del informe ${reportId}: $($_.Exception.Message)" return @() } } # Descargar todas las páginas de todos los informes foreach ($reportId in $reportIds) { $pages = Get-ReportPages -reportId $reportId if ($pages.Count -eq 0) { Write-Log "No se pudieron obtener las páginas del informar ${reportId}. Saltando al siguiente informe." continuar } foreach ($página en $páginas) { Descargar-ReportPageImage -reportId $reportId -pageName $page.name } } Write-Log "Todas las paginas de todos los informes han sido descargadas." Error Someone please help or can give me another alternative to carry out this process.
Service Account - Credentials to refresh data, error by Refresh
Hi, I would like to understand something since me and my colleagues are using a common Service account to schedule the refresh of our data sources in Report Server. The SVC is authorized correctly on every SQL Server, Folder or source we are using. The data refresh seems to be working just partially, sometimes it happens succesfully, several times it throws the error. The below is an example of it, I didnt change anything between the 2 schedules, same da different results. It seems to be some kind of Queue error, probably too many Reports are due to refresh at the same time, but I can't find any info about it on the web. Is there somebody who knows about this issue and the related solution? Many thanks
