Forum Discussion

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
11 months ago

Premium per user - Loop through workspace and get Connection Strings

I have a premium per user license and a workspace set up for premium per user.   I'm testing out ways to pull out the connections strings, the actual table name, view name etc that is used to popul...
Need Help
v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi TCavins,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

 

Thank you.

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
11 months ago

I am unable to do anything with the Tabular Object Model.  Anything that I take from examples, the server.Connect says invalid connection string.

I am able to create a token and authenticate with the API, but that does not give me the name of the views/tables etc that are in the datasources for each report.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    11 months ago

    Hi TCavins,

    I have done the repro at my and got the below output:

    Below code should run in Powershell

    Connect-PowerBIServiceAccount

$workspaceId = "Enter your Workspacae ID here"

$datasets = Get-PowerBIDataset -WorkspaceId $workspaceId

foreach ($ds in $datasets) {

    Write-Host "==============================="
    Write-Host "Dataset: $($ds.Name)"
    Write-Host "==============================="

    # Datasources
    $urlDS = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/datasets/$($ds.Id)/datasources"
    $sources = Invoke-PowerBIRestMethod -Url $urlDS -Method GET | ConvertFrom-Json
    $sources
    Write-Host "`nData Sources:"
    foreach ($s in $sources.value) {
        Write-Host "  Type: $($s.datasourceType)"
        Write-Host "  Server: $($s.connectionDetails.server)"
        Write-Host "  Database: $($s.connectionDetails.database)"
        Write-Host ""
    }

    Write-Host "`n"
}

     

    Thank you.