Forum Discussion

poweruser1's avatar
poweruser1
Frequent Visitor
3 years ago
Solved

Create partition via powershell error

I am trying to write a Powershell script to create a partition in a Power BI dataset. Anyone know how to resolve this error? I am receiving the following error: My Powershell Code: $m_code = ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi poweruser1,

    Perhaps you can take a look the following sample code if it help with your scenario:

    $groupID = "<your group ID>"
$datasetID = "<your dataset ID>"
$token = Get-PowerBIAccessToken
$authHeader = @{ "Authorization" = "Bearer $token" }
$uri = "https://api.powerbi.com/v1.0/myorg/groups/$groupID/datasets/$datasetID/Partitions"
$body = @{
    "name" = "ImportName"
    "mode" = "Import"
    "source" = @{
        "type" = "Query"
        "query" = "SELECT * FROM $tableName"
        "dataSource" = @{
            "type" = "Sql"
            "connectionDetails" = @{
				"server" = "$serverName.database.windows.net"
				"database" = "$databaseName"
                "authentication" = "Windows"
            }
        }
    }
}
$jsonBody = $body | ConvertTo-Json
Invoke-RestMethod -Uri $uri -Headers $authHeader -Method Post -Body $jsonBody

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi poweruser1,

Perhaps you can take a look the following sample code if it help with your scenario:

$groupID = "<your group ID>"
$datasetID = "<your dataset ID>"
$token = Get-PowerBIAccessToken
$authHeader = @{ "Authorization" = "Bearer $token" }
$uri = "https://api.powerbi.com/v1.0/myorg/groups/$groupID/datasets/$datasetID/Partitions"
$body = @{
    "name" = "ImportName"
    "mode" = "Import"
    "source" = @{
        "type" = "Query"
        "query" = "SELECT * FROM $tableName"
        "dataSource" = @{
            "type" = "Sql"
            "connectionDetails" = @{
				"server" = "$serverName.database.windows.net"
				"database" = "$databaseName"
                "authentication" = "Windows"
            }
        }
    }
}
$jsonBody = $body | ConvertTo-Json
Invoke-RestMethod -Uri $uri -Headers $authHeader -Method Post -Body $jsonBody

Regards,

Xiaoxin Sheng