Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Is there posibility to call power admin api using sql queries?
For example, I need to get list of my organizational workspaces and save this information into some table on sql server database.
Run the API call in Powershell and push the resultset into a SQL Server database table.
is there some documentation about using cmdlets for powershell ?
what protocols it is used, what path and ports should be opened for requests?
In my case, server (where my sqldatabase exists) doesn't have access to internet, so I need to ask my network team-members to open access to powerbi site.... or smth like this...
These are standard Powershell functions. Nothing but HTTPS.
Something along these lines
$dataset = "9941f7c0-xxxx-4382-959c-731a752e9a8f"
$URI = "https://api.powerbi.com/v1.0/myorg/datasets/$dataset/executeQueries"
$query = '
EVALUATE
<your DAX here>
'
$body = '{ queries: [ { query : "' + $query.Replace('"','\"') + '" } ],"serializersettings":{ "includeNulls":true} }'
$res = Invoke-RestMethod -Headers $authHeader -Uri $URI -Body $body -Method POST
$rows = $res.Substring(3) | ConvertFrom-Json | Select-Object -Expand results | Select-Object -Expand tables | Select-Object -Expand rows
,$rows | Write-SqlTableData -ServerInstance "server" -DatabaseName "database" -SchemaName "dbo" -TableName "table"
Thank you for answer. I will try to do it. Let you know if I have additional queations.