Export data from powerbi via Powershell

Hello Icaro99,

Can you please try this PowerShell script to connect to the Power BI model, execute a query, and save the results to a .txt file:

Import-Module SqlServer

$powerBIConnection = "localhost:<PORT>" # Replace <PORT> with the Power BI port found in Step 1
$databaseName = "Model" # Default Power BI model database

$query = @"
EVALUATE
SUMMARIZE(
    'TABELLAPROVA',
    'TABELLAPROVA'[id_key],
    "MaxPeriod", MAX('TABELLAPROVA'[period])
)
"@

$result = Invoke-ASCmd -Server $powerBIConnection -Database $databaseName -Query $query

$outputFilePath = "C:\Path\To\Output.txt"
$result.Tables[0].Rows | ForEach-Object {
    "$($_.id_key), $($_.MaxPeriod)" | Out-File -Append -FilePath $outputFilePath
}

Write-Host "Query results saved to $outputFilePath"

Hi Icaro99,

Thanks for your response.

Yes, the -Server parameter is necessary in both commands because it tells the command where to connect to execute the operation.

If you want to query data and refresh tables in the same workflow, you'll need to use both commands as follows:

• Invoke-ProcessTable for refreshing data in tables.
• Invoke-ASCmd for querying or executing DAX/MDX commands.

Hope this helps.