Azure partition refresh issue
Hi all, I am refreshing ds partitions via Azur runbooks and powershell scripts. This week I noticed that the error below appears (previously everything worked fine) This is the line that its calling: $Srv.Connect($connectionString) And the connection string: $connectionString ="Provider=MSOLAP;Data Source=$XmlaEndpoint;User ID=app:$PowerBIServiceApplicationID;Password=$PowerBIServiceApplicationKey;Persist Security Info=True;Impersonation Level=Impersonate" Do you have any suggestions why suddenly this script stoped working a week ago? Thanks in advance!
Data source unreachable
I have created a PBI report in the desktop version using excel files from OneDrive and dataset from Azure. In the desktop version all works well, but when I publish it I get an error. The "File" hyperlink just sends me back to the main page. And according to my IT team, there's no Gateway for Azure report. I have tried to publish a report with just excel files from OD or just some tables and measures from Azure - it works. But when I publish the combination of these two, the visuals don't work. I have checked other threads here but nothing seems to help. .
Access/Export geocoded coordinates from Azure Maps for PowerBI
Hi, I just recently started experimenting with the Azure Maps app for PowerBI. So far I've been able to successfully map street addresses. My question is whether - once geocoded - how can I export the lat/long pairs? When I export the data from the map with geocoded addresses I only get the fields from my data tables. Thanks.
How to access the PowerBI report using Azure Automation Powershell Runbook
Hi, My requirement is to access a PowerBI Report using the Azure Automation Powershell Runbook. Have tried couple of ways to acheive it, but was not successful and have provided them below. Can you please suggest. - Created App registration for PowerBI in Azure Active directory. - Have used the below code in Azure Powershell runbook to invoke the REST API of the PowerBI. Code: $connection = Get-AutomationConnection -Name 'AzureRunAsConnection' Connect-AzAccount -ServicePrincipal -Tenant $connection.TenantID -ApplicationId $connection.ApplicationID -CertificateThumbprint $connection.CertificateThumbprint $tenantDomain = 'XXXXXXXXXXXX.net' $TenantId='XXXXXXX-XXXX-XXX-XXX-9ba90260bca6' $ApplicationClientId = 'XXXXXXXX-XXXX-XXXX-XXXX-21d9e848ebad' $ApplicationClientSecretKey = 'XXX-X~XXXXXXXXX-XXX-XXX~XX~12ReGrs' [uri]$url = 'https://app.powerbi.com/' Write-Host "Authorization..." -ForegroundColor Yellow Add-Type -AssemblyName System.Web [string]$absoluteURL = $url.AbsoluteUri.Remove($url.AbsoluteUri.Length-1,1) [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 Write-Host "1" $Body = @{ "client_id" = $ApplicationClientId "client_secret" = $ApplicationClientSecretKey "grant_type" = 'client_credentials' "scope" = "$absoluteURL/.default" } Write-Host "2" Write-Host " URL" $absoluteURL -ForegroundColor Yellow Write-Host " Body" -ForegroundColor Yellow $Body Write-Host " Trying to get authorization..." -ForegroundColor Yellow Write-Host "3" $login = $null $login = Invoke-RestMethod -Method Post -Uri "https://login.microsoftonline.com/$tenantDomain/oauth2/v2.0/token" -Body $Body -ContentType 'application/x-www-form-urlencoded' -Verbose $login $Bearer = $null [string]$Bearer = $login.access_token $headers = @{ "Accept" = "application/xml" "Accept-Charset" = "UTF-8" "Authorization" = "Bearer $Bearer" "Host" = "$($url.Host)" } [System.UriBuilder] $ListRecordsURL = $url $resultREST = Invoke-RestMethod -Method Get -Uri $ListRecordsURL.Uri.AbsoluteUri ` -Headers $headers -ContentType 'application/json; charset=utf-8' -Verbose $resultREST Getting the below Error: Thanks & Regards Srujana U
