Bad Request when publishing a report - Power BI Actions

[luke-barnett]

Describe the issue A clear and concise description of what the issue is.

Extension

• Extension: Power BI Actions
• Version: 5.4.54

To Reproduce Steps to reproduce the behavior:

1. Simple publish of report via Azure Pipelines
2. Error 400 Bad request

Expected behavior The report is published to Power BI

Situation (please complete the following information):

• Agent type: Windows Hosted
• Autentication: Service Principal
• Extension Version: 5.4.54

Log info

2024-11-12T21:11:35.8052145Z ##[debug]Evaluating condition for step: 'Publish PowerBI Report' 2024-11-12T21:11:35.8053507Z ##[debug]Evaluating: SucceededNode() 2024-11-12T21:11:35.8053825Z ##[debug]Evaluating SucceededNode: 2024-11-12T21:11:35.8054823Z ##[debug]=> True 2024-11-12T21:11:35.8055172Z ##[debug]Result: True 2024-11-12T21:11:35.8055488Z ##[section]Starting: Publish PowerBI Report 2024-11-12T21:11:35.8077227Z ============================================================================== 2024-11-12T21:11:35.8077391Z Task : Power BI Actions 2024-11-12T21:11:35.8077637Z Description : Release Task Power BI Actions 2024-11-12T21:11:35.8077755Z Version : 5.4.54 2024-11-12T21:11:35.8077832Z Author : Maik van der Gaag 2024-11-12T21:11:35.8078569Z Help : 2024-11-12T21:11:35.8078687Z ============================================================================== 2024-11-12T21:11:38.0292746Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2024-11-12T21:11:38.0293477Z Starting Power BI Actions extension 2024-11-12T21:11:38.0295277Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1. 2024-11-12T21:11:38.0296891Z ### Required Module is needed. Importing now... 2024-11-12T21:11:38.0297818Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2024-11-12T21:11:38.0299909Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2024-11-12T21:11:38.0300892Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2024-11-12T21:11:38.0302167Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2024-11-12T21:11:38.0303100Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2024-11-12T21:11:38.0303803Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2024-11-12T21:11:38.0304360Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2024-11-12T21:11:38.0304905Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2024-11-12T21:11:38.0305625Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2024-11-12T21:11:38.0306160Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2024-11-12T21:11:38.0306723Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2024-11-12T21:11:38.0308439Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2024-11-12T21:11:38.0309068Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2024-11-12T21:11:38.0339459Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2024-11-12T21:11:38.0340663Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2024-11-12T21:11:38.0342166Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2024-11-12T21:11:38.0343265Z ##[debug]Importing alias 'Login-PowerBI'. 2024-11-12T21:11:38.0344170Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2024-11-12T21:11:38.0345056Z ##[debug]Importing alias 'Logout-PowerBI'. 2024-11-12T21:11:38.0345989Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2024-11-12T21:11:38.0346903Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2024-11-12T21:11:38.0348409Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2024-11-12T21:11:38.0350027Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2024-11-12T21:11:38.0351413Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2024-11-12T21:11:38.0354738Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2024-11-12T21:11:38.0356351Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2024-11-12T21:11:38.0362538Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2024-11-12T21:11:38.0363007Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2024-11-12T21:11:38.0363636Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2024-11-12T21:11:38.0364257Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2024-11-12T21:11:38.0364850Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2024-11-12T21:11:38.0365280Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2024-11-12T21:11:38.0365690Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2024-11-12T21:11:38.0366115Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2024-11-12T21:11:38.0366536Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2024-11-12T21:11:38.0366969Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2024-11-12T21:11:38.0367397Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2024-11-12T21:11:38.0367820Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2024-11-12T21:11:38.0368248Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2024-11-12T21:11:38.0368656Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2024-11-12T21:11:38.0369082Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2024-11-12T21:11:38.0369495Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2024-11-12T21:11:38.0369977Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2024-11-12T21:11:38.0370403Z ##[debug]Importing alias 'New-PowerBIGroup'. 2024-11-12T21:11:38.0370823Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2024-11-12T21:11:38.0371225Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2024-11-12T21:11:38.0387016Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2024-11-12T21:11:38.0430657Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2024-11-12T21:11:38.0908463Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2024-11-12T21:11:38.0931608Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2024-11-12T21:11:38.0933083Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2024-11-12T21:11:38.0934152Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2024-11-12T21:11:38.0935137Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2024-11-12T21:11:38.0936133Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2024-11-12T21:11:38.0937126Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2024-11-12T21:11:38.0938329Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2024-11-12T21:11:38.0939338Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2024-11-12T21:11:38.0940776Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2024-11-12T21:11:38.0941850Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2024-11-12T21:11:38.0960060Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2024-11-12T21:11:38.0980545Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2024-11-12T21:11:38.0999242Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2024-11-12T21:11:38.1019025Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2024-11-12T21:11:38.1060156Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2024-11-12T21:11:38.1061456Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2024-11-12T21:11:38.1081171Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2024-11-12T21:11:38.1087392Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2024-11-12T21:11:38.1135922Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2024-11-12T21:11:38.1137443Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2024-11-12T21:11:38.1156501Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2024-11-12T21:11:38.1196216Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2024-11-12T21:11:38.1273013Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2024-11-12T21:11:38.1293055Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2024-11-12T21:11:38.1705562Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2024-11-12T21:11:38.1802441Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2024-11-12T21:11:38.1847988Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2024-11-12T21:11:38.1849781Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2024-11-12T21:11:38.1873031Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2024-11-12T21:11:38.1908286Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2024-11-12T21:11:38.1909556Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2024-11-12T21:11:38.1927193Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2024-11-12T21:11:38.1964986Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2024-11-12T21:11:38.2001779Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2024-11-12T21:11:38.2033687Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2024-11-12T21:11:38.2052711Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2024-11-12T21:11:38.2075892Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2024-11-12T21:11:38.2097797Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2024-11-12T21:11:38.2127863Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2024-11-12T21:11:38.2149560Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2024-11-12T21:11:38.2168614Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2024-11-12T21:11:38.2188883Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2024-11-12T21:11:38.2213713Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2024-11-12T21:11:38.2230673Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2024-11-12T21:11:38.2254182Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2024-11-12T21:11:38.2273820Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2024-11-12T21:11:38.2299755Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2024-11-12T21:11:38.2341939Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2024-11-12T21:11:38.2365892Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2024-11-12T21:11:38.2433018Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2024-11-12T21:11:38.2453804Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2024-11-12T21:11:38.2503172Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2024-11-12T21:11:38.2508320Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2024-11-12T21:11:38.2513580Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2024-11-12T21:11:38.2527253Z ### Trying to import the incorporated module for PowerBI 2024-11-12T21:11:38.2553206Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1'. 2024-11-12T21:11:38.4024397Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2024-11-12T21:11:38.4064290Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2024-11-12T21:11:38.4085934Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2024-11-12T21:11:38.4106534Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2024-11-12T21:11:38.4151302Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2024-11-12T21:11:38.4170963Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2024-11-12T21:11:38.4191249Z ##[debug]Exporting function 'Set-DatasetOwnership'. 2024-11-12T21:11:38.4209977Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'. 2024-11-12T21:11:38.4231084Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2024-11-12T21:11:38.4250382Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2024-11-12T21:11:38.4269608Z ##[debug]Exporting function 'Invoke-API'. 2024-11-12T21:11:38.4288640Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2024-11-12T21:11:38.4308305Z ##[debug]Exporting function 'New-DatasetRefresh'. 2024-11-12T21:11:38.4328516Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2024-11-12T21:11:38.4349473Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2024-11-12T21:11:38.4370722Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2024-11-12T21:11:38.4389769Z ##[debug]Exporting function 'Get-PowerBIReport'. 2024-11-12T21:11:38.4408944Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2024-11-12T21:11:38.4447053Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2024-11-12T21:11:38.4478176Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2024-11-12T21:11:38.4483824Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2024-11-12T21:11:38.4505236Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2024-11-12T21:11:38.4525681Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2024-11-12T21:11:38.4544376Z ##[debug]Exporting function 'Import-PowerBIFile'. 2024-11-12T21:11:38.4562851Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2024-11-12T21:11:38.4581093Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2024-11-12T21:11:38.4600507Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2024-11-12T21:11:38.4624243Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2024-11-12T21:11:38.4668698Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2024-11-12T21:11:38.4688155Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2024-11-12T21:11:38.4707905Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2024-11-12T21:11:38.4729162Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2024-11-12T21:11:38.4738662Z ##[debug]Exporting function 'Set-Capacity'. 2024-11-12T21:11:38.4752495Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2024-11-12T21:11:38.4772822Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2024-11-12T21:11:38.4792197Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2024-11-12T21:11:38.4811437Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2024-11-12T21:11:38.4832864Z ##[debug]Exporting function 'Publish-TabularEditor'. 2024-11-12T21:11:38.4852390Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2024-11-12T21:11:38.4872544Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2024-11-12T21:11:38.4911472Z ##[debug]Exporting function 'Set-PowerBIDatasourceCredentials'. 2024-11-12T21:11:38.4931074Z ##[debug]Exporting function 'Update-DatasourceCredentialsInGateway'. 2024-11-12T21:11:38.4961743Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2024-11-12T21:11:38.4982230Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2024-11-12T21:11:38.5004396Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2024-11-12T21:11:38.5024032Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2024-11-12T21:11:38.5042725Z ##[debug]Importing function 'Get-PowerBICapacity'. 2024-11-12T21:11:38.5063323Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2024-11-12T21:11:38.5082354Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2024-11-12T21:11:38.5101753Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2024-11-12T21:11:38.5120671Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2024-11-12T21:11:38.5152741Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2024-11-12T21:11:38.5184066Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2024-11-12T21:11:38.5236757Z ##[debug]Importing function 'Get-PowerBIGateways'. 2024-11-12T21:11:38.5254928Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2024-11-12T21:11:38.5283028Z ##[debug]Importing function 'Get-PowerBiParameters'. 2024-11-12T21:11:38.5306443Z ##[debug]Importing function 'Get-PowerBIReport'. 2024-11-12T21:11:38.5326772Z ##[debug]Importing function 'Import-PowerBIFile'. 2024-11-12T21:11:38.5348703Z ##[debug]Importing function 'Invoke-API'. 2024-11-12T21:11:38.5369611Z ##[debug]Importing function 'New-DatasetRefresh'. 2024-11-12T21:11:38.5392163Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2024-11-12T21:11:38.5415695Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2024-11-12T21:11:38.5437952Z ##[debug]Importing function 'Publish-PowerBIFile'. 2024-11-12T21:11:38.5462608Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2024-11-12T21:11:38.5485562Z ##[debug]Importing function 'Publish-TabularEditor'. 2024-11-12T21:11:38.5506638Z ##[debug]Importing function 'Redo-PowerBIReport'. 2024-11-12T21:11:38.5528219Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2024-11-12T21:11:38.5549813Z ##[debug]Importing function 'Remove-PowerBIReport'. 2024-11-12T21:11:38.5572267Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2024-11-12T21:11:38.5592642Z ##[debug]Importing function 'Set-Capacity'. 2024-11-12T21:11:38.5613042Z ##[debug]Importing function 'Set-DatasetOwnership'. 2024-11-12T21:11:38.5636983Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'. 2024-11-12T21:11:38.5659590Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2024-11-12T21:11:38.5686846Z ##[debug]Importing function 'Set-PowerBIDatasourceCredentials'. 2024-11-12T21:11:38.5708344Z ##[debug]Importing function 'Set-RefreshSchedule'. 2024-11-12T21:11:38.5731337Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2024-11-12T21:11:38.5752266Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2024-11-12T21:11:38.5773631Z ##[debug]Importing function 'Update-DatasourceCredentialsInGateway'. 2024-11-12T21:11:38.5799175Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2024-11-12T21:11:38.5817788Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2024-11-12T21:11:38.5837094Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2024-11-12T21:11:38.5859271Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2024-11-12T21:11:38.5883232Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2024-11-12T21:11:38.5903165Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2024-11-12T21:11:38.6349926Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '235bbd85-cd97-4572-829f-8c873ba91c9d' 2024-11-12T21:11:38.6507460Z ##[debug]ENDPOINT_URL_235bbd85-cd97-4572-829f-8c873ba91c9d: 'https://api.powerbi.com/v1.0/myorg' 2024-11-12T21:11:38.6535657Z ##[debug]ENDPOINT_AUTH_235bbd85-cd97-4572-829f-8c873ba91c9d: '****' 2024-11-12T21:11:38.6566560Z ##[debug]ENDPOINT_DATA_235bbd85-cd97-4572-829f-8c873ba91c9d: '{"OrganizationType":"Public"}' 2024-11-12T21:11:38.7505216Z ##[debug]{ 2024-11-12T21:11:38.7515929Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2024-11-12T21:11:38.7525827Z ##[debug] "Data": { 2024-11-12T21:11:38.7542120Z ##[debug] "OrganizationType": "Public" 2024-11-12T21:11:38.7557861Z ##[debug] }, 2024-11-12T21:11:38.7572981Z ##[debug] "Auth": { 2024-11-12T21:11:38.7590772Z ##[debug] "parameters": { 2024-11-12T21:11:38.7605342Z ##[debug] "TenantId": "", 2024-11-12T21:11:38.7620771Z ##[debug] "ClientId": "", 2024-11-12T21:11:38.7637129Z ##[debug] "ClientCertificate": "", 2024-11-12T21:11:38.7655507Z ##[debug] "ClientSecret": *** 2024-11-12T21:11:38.7670292Z ##[debug] }, 2024-11-12T21:11:38.7692490Z ##[debug] "scheme": "None" 2024-11-12T21:11:38.7709633Z ##[debug] } 2024-11-12T21:11:38.7725281Z ##[debug]} 2024-11-12T21:11:39.3299729Z ##[debug]9:11:39 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2024-11-12T21:11:39.3329020Z ##[debug]9:11:39 PM - Cmdlet version: 1.2.1077.0 2024-11-12T21:11:39.3766681Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/94260f03-0793-484a-91cf-bebe584319bc 2024-11-12T21:11:39.5263087Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39] Found 0 cache accounts and 0 broker accounts 2024-11-12T21:11:39.5351977Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(5185ae52-aaf0-4b38-be7d-b3afc1ff21db) 2024-11-12T21:11:39.5390591Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === AcquireTokenForClientParameters === 2024-11-12T21:11:39.5409387Z ##[debug]SendX5C: False 2024-11-12T21:11:39.5437030Z ##[debug]WithAzureRegion: False 2024-11-12T21:11:39.5444445Z ##[debug]RegionToUse: 2024-11-12T21:11:39.5461133Z ##[debug]ForceRefresh: False 2024-11-12T21:11:39.5478378Z ##[debug] 2024-11-12T21:11:39.5644957Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] 2024-11-12T21:11:39.5661945Z ##[debug]=== Request Data === 2024-11-12T21:11:39.5678326Z ##[debug]Authority Provided? - True 2024-11-12T21:11:39.5696123Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-12T21:11:39.5711631Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-12T21:11:39.5730814Z ##[debug]ApiId - AcquireTokenForClient 2024-11-12T21:11:39.5755961Z ##[debug]IsConfidentialClient - True 2024-11-12T21:11:39.5775729Z ##[debug]SendX5C - False 2024-11-12T21:11:39.5795128Z ##[debug]LoginHint ? False 2024-11-12T21:11:39.5815821Z ##[debug]IsBrokerConfigured - False 2024-11-12T21:11:39.5833470Z ##[debug]HomeAccountId - False 2024-11-12T21:11:39.5849861Z ##[debug]CorrelationId - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db 2024-11-12T21:11:39.5865347Z ##[debug] 2024-11-12T21:11:39.5907070Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === Token Acquisition (ClientCredentialRequest) started: 2024-11-12T21:11:39.5922913Z ##[debug]
2024-11-12T21:11:39.5957971Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-12T21:11:39.6375446Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Fetching instance discovery from the network from host login.microsoftonline.com. 2024-11-12T21:11:40.1238721Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Resolving authority endpoints... Already resolved? - FALSE 2024-11-12T21:11:40.1266164Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2024-11-12T21:11:40.1289880Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Checking client info returned from the server.. 2024-11-12T21:11:40.1314710Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Saving Token Response to cache.. 2024-11-12T21:11:40.1339515Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] ID Token not present in response. 2024-11-12T21:11:40.1417845Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Saving AT in cache and removing overlapping ATs... 2024-11-12T21:11:40.1419664Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2024-11-12T21:11:40.1437653Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Intersecting scope entries count - 0 2024-11-12T21:11:40.1458941Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 === 2024-11-12T21:11:40.1485572Z ##[debug]9:11:40 PM - Connect-PowerBIServiceAccount end processing. 2024-11-12T21:11:40.1892433Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\report*.pbix' 2024-11-12T21:11:40.1922864Z ##[debug]INPUT_WORKSPACENAME: 'report-dev' 2024-11-12T21:11:40.1950411Z ##[debug]INPUT_OVERWRITE: 'true' 2024-11-12T21:11:40.2001166Z ##[debug] Converted to bool: True 2024-11-12T21:11:40.2030242Z ##[debug]INPUT_CREATE: 'false' 2024-11-12T21:11:40.2054102Z ##[debug] Converted to bool: False 2024-11-12T21:11:40.2082798Z ##[debug]INPUT_ACTION: 'Publish' 2024-11-12T21:11:40.2110141Z ##[debug]INPUT_DATASETNAME (empty) 2024-11-12T21:11:40.2167628Z ##[debug]INPUT_OLDURL (empty) 2024-11-12T21:11:40.2201925Z ##[debug]INPUT_NEWURL (empty) 2024-11-12T21:11:40.2222990Z ##[debug]INPUT_OLDSERVER (empty) 2024-11-12T21:11:40.2249573Z ##[debug]INPUT_NEWSERVER (empty) 2024-11-12T21:11:40.2277517Z ##[debug]INPUT_OLDDATABASE (empty) 2024-11-12T21:11:40.2308338Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2024-11-12T21:11:40.2334649Z ##[debug]INPUT_NEWDATABASE (empty) 2024-11-12T21:11:40.2364248Z ##[debug]INPUT_PERMISSION (empty) 2024-11-12T21:11:40.2393284Z ##[debug]INPUT_USERS (empty) 2024-11-12T21:11:40.2436025Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2024-11-12T21:11:40.2478257Z ##[debug]INPUT_UPDATEALL: 'false' 2024-11-12T21:11:40.2514982Z ##[debug] Converted to bool: False 2024-11-12T21:11:40.2558670Z ##[debug]INPUT_SKIPREPORT: 'false' 2024-11-12T21:11:40.2585544Z ##[debug] Converted to bool: False 2024-11-12T21:11:40.2627934Z ##[debug]INPUT_SCOPE: 'Private' 2024-11-12T21:11:40.2657993Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2024-11-12T21:11:40.2686551Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2024-11-12T21:11:40.2714502Z ##[debug]INPUT_PARAMETERINPUT (empty) 2024-11-12T21:11:40.2742693Z ##[debug]INPUT_GATEWAYNAME (empty) 2024-11-12T21:11:40.2791017Z ##[debug]INPUT_REPORTNAME (empty) 2024-11-12T21:11:40.2807642Z ##[debug]INPUT_CAPACITYNAME (empty) 2024-11-12T21:11:40.2821133Z ##[debug]INPUT_USERNAME (empty) 2024-11-12T21:11:40.2848785Z ##[debug]INPUT_PASSWORD (empty) 2024-11-12T21:11:40.3718437Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2024-11-12T21:11:40.3721517Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2024-11-12T21:11:40.3749674Z ##[debug] Converted to bool: False 2024-11-12T21:11:40.3776247Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2024-11-12T21:11:40.3802532Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2024-11-12T21:11:40.3851411Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2024-11-12T21:11:40.3881641Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2024-11-12T21:11:40.3908179Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2024-11-12T21:11:40.3934750Z ##[debug]INPUT_DATASETACCESSRIGHT (empty) 2024-11-12T21:11:40.3958877Z ##[debug]INPUT_SERVER (empty) 2024-11-12T21:11:40.3983860Z ##[debug]INPUT_DATABASE (empty) 2024-11-12T21:11:40.4006933Z ##[debug]INPUT_TENANTID (empty) 2024-11-12T21:11:40.4037739Z ##[debug]INPUT_SERVICEPRINCIPALID (empty) 2024-11-12T21:11:40.4072204Z ##[debug]INPUT_SERVICEPRINCIPALKEY (empty) 2024-11-12T21:11:40.4079137Z ##[debug]WorkspaceName : report-dev 2024-11-12T21:11:40.4100678Z ##[debug]Create : False 2024-11-12T21:11:40.4120694Z ##[debug]File patern : D:\a\1\report*.pbix 2024-11-12T21:11:40.4140970Z ##[debug]Remove report : False 2024-11-12T21:11:40.4343056Z Getting Power BI Workspace properties; report-dev 2024-11-12T21:11:40.4422197Z ##[debug]9:11:40 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2024-11-12T21:11:40.4442752Z ##[debug]9:11:40 PM - Cmdlet version: 1.2.1077.0 2024-11-12T21:11:40.5001617Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40] Found 0 cache accounts and 0 broker accounts 2024-11-12T21:11:40.5021798Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(bbb8b42e-6e6e-444f-b35a-0e54ad592dcc) 2024-11-12T21:11:40.5043635Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === AcquireTokenForClientParameters === 2024-11-12T21:11:40.5057365Z ##[debug]SendX5C: False 2024-11-12T21:11:40.5086928Z ##[debug]WithAzureRegion: False 2024-11-12T21:11:40.5100954Z ##[debug]RegionToUse: 2024-11-12T21:11:40.5115979Z ##[debug]ForceRefresh: False 2024-11-12T21:11:40.5129900Z ##[debug] 2024-11-12T21:11:40.5152994Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] 2024-11-12T21:11:40.5167845Z ##[debug]=== Request Data === 2024-11-12T21:11:40.5182364Z ##[debug]Authority Provided? - True 2024-11-12T21:11:40.5196612Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-12T21:11:40.5211185Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-12T21:11:40.5229626Z ##[debug]ApiId - AcquireTokenForClient 2024-11-12T21:11:40.5246327Z ##[debug]IsConfidentialClient - True 2024-11-12T21:11:40.5261512Z ##[debug]SendX5C - False 2024-11-12T21:11:40.5295667Z ##[debug]LoginHint ? False 2024-11-12T21:11:40.5312720Z ##[debug]IsBrokerConfigured - False 2024-11-12T21:11:40.5329194Z ##[debug]HomeAccountId - False 2024-11-12T21:11:40.5345715Z ##[debug]CorrelationId - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc 2024-11-12T21:11:40.5359617Z ##[debug] 2024-11-12T21:11:40.5381633Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === Token Acquisition (ClientCredentialRequest) started: 2024-11-12T21:11:40.5397918Z ##[debug]
2024-11-12T21:11:40.5412933Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-12T21:11:40.5479349Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:40) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)] 2024-11-12T21:11:40.5514960Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 === 2024-11-12T21:11:41.3761829Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'report-dev'&$top=100 2024-11-12T21:11:41.3781968Z ##[debug]Status Code: OK (200) 2024-11-12T21:11:41.3803451Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace end processing. 2024-11-12T21:11:41.3878789Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]b13833a5-3cff-4582-9c20-b1898fa06718 2024-11-12T21:11:41.3905855Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2024-11-12T21:11:41.3933752Z ##[debug]9:11:41 PM - Cmdlet version: 1.2.1077.0 2024-11-12T21:11:41.3957568Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41] Found 0 cache accounts and 0 broker accounts 2024-11-12T21:11:41.3979349Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(e839bf6c-b727-4eb1-a366-cf76aa388421) 2024-11-12T21:11:41.3999595Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === AcquireTokenForClientParameters === 2024-11-12T21:11:41.4014193Z ##[debug]SendX5C: False 2024-11-12T21:11:41.4029836Z ##[debug]WithAzureRegion: False 2024-11-12T21:11:41.4044429Z ##[debug]RegionToUse: 2024-11-12T21:11:41.4059758Z ##[debug]ForceRefresh: False 2024-11-12T21:11:41.4076673Z ##[debug] 2024-11-12T21:11:41.4098483Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] 2024-11-12T21:11:41.4113934Z ##[debug]=== Request Data === 2024-11-12T21:11:41.4129580Z ##[debug]Authority Provided? - True 2024-11-12T21:11:41.4144472Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-12T21:11:41.4160336Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-12T21:11:41.4177593Z ##[debug]ApiId - AcquireTokenForClient 2024-11-12T21:11:41.4192519Z ##[debug]IsConfidentialClient - True 2024-11-12T21:11:41.4206789Z ##[debug]SendX5C - False 2024-11-12T21:11:41.4220657Z ##[debug]LoginHint ? False 2024-11-12T21:11:41.4240480Z ##[debug]IsBrokerConfigured - False 2024-11-12T21:11:41.4255250Z ##[debug]HomeAccountId - False 2024-11-12T21:11:41.4270246Z ##[debug]CorrelationId - e839bf6c-b727-4eb1-a366-cf76aa388421 2024-11-12T21:11:41.4286212Z ##[debug] 2024-11-12T21:11:41.4308569Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === Token Acquisition (ClientCredentialRequest) started: 2024-11-12T21:11:41.4323573Z ##[debug]
2024-11-12T21:11:41.4343090Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-12T21:11:41.4367267Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:41) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)] 2024-11-12T21:11:41.4390067Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 === 2024-11-12T21:11:41.8661962Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'report-dev'&$top=100 2024-11-12T21:11:41.8682774Z ##[debug]Status Code: OK (200) 2024-11-12T21:11:41.8703002Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace end processing. 2024-11-12T21:11:41.8805558Z Trying to publish PowerBI File: D:\a\1\report\report.pbix 2024-11-12T21:11:41.8856845Z Checking for existing Reports with the name: report 2024-11-12T21:11:41.8937609Z ##[debug]9:11:41 PM - New-PowerBIReport begin processing with ParameterSet Workspace. 2024-11-12T21:11:41.9006122Z ##[debug]9:11:41 PM - Cmdlet version: 1.2.1077.0 2024-11-12T21:11:41.9045343Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41] Found 0 cache accounts and 0 broker accounts 2024-11-12T21:11:41.9064688Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(72fec461-0cd1-41cb-bdba-f84f31a0f6be) 2024-11-12T21:11:41.9086109Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === AcquireTokenForClientParameters === 2024-11-12T21:11:41.9100984Z ##[debug]SendX5C: False 2024-11-12T21:11:41.9116171Z ##[debug]WithAzureRegion: False 2024-11-12T21:11:41.9131960Z ##[debug]RegionToUse: 2024-11-12T21:11:41.9147283Z ##[debug]ForceRefresh: False 2024-11-12T21:11:41.9161507Z ##[debug] 2024-11-12T21:11:41.9184133Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] 2024-11-12T21:11:41.9199461Z ##[debug]=== Request Data === 2024-11-12T21:11:41.9214925Z ##[debug]Authority Provided? - True 2024-11-12T21:11:41.9230275Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-12T21:11:41.9956196Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-12T21:11:41.9971404Z ##[debug]ApiId - AcquireTokenForClient 2024-11-12T21:11:41.9986917Z ##[debug]IsConfidentialClient - True 2024-11-12T21:11:42.0001512Z ##[debug]SendX5C - False 2024-11-12T21:11:42.0019173Z ##[debug]LoginHint ? False 2024-11-12T21:11:42.0034062Z ##[debug]IsBrokerConfigured - False 2024-11-12T21:11:42.0048120Z ##[debug]HomeAccountId - False 2024-11-12T21:11:42.0063549Z ##[debug]CorrelationId - 72fec461-0cd1-41cb-bdba-f84f31a0f6be 2024-11-12T21:11:42.0079126Z ##[debug] 2024-11-12T21:11:42.0113636Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === Token Acquisition (ClientCredentialRequest) started: 2024-11-12T21:11:42.0128590Z ##[debug]
2024-11-12T21:11:42.0143641Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-12T21:11:42.0167068Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:42 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:42) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)] 2024-11-12T21:11:42.0194126Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:42 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 === 2024-11-12T21:11:43.0278438Z ##[debug]Agent environment resources - Disk: D:\ Available 12446.73 MB out of 14334.00 MB, Memory: Used 2029.00 MB out of 7167.00 MB, CPU: Usage 45.00% 2024-11-12T21:11:44.5557248Z Done processing Power BI Actions 2024-11-12T21:11:44.6294147Z ##[debug]Caught exception from task script. 2024-11-12T21:11:44.6330275Z ##[debug]Error record: 2024-11-12T21:11:44.7065333Z ##[debug]New-PowerBIReport : Operation returned an invalid status code 'BadRequest' 2024-11-12T21:11:44.7080369Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1:797 char:27 2024-11-12T21:11:44.7094613Z ##[debug]+ ... $report = New-PowerBIReport -Path $filePath -Name $fileToPublish -W ... 2024-11-12T21:11:44.7108983Z ##[debug]+ ~~~~~~~~~~~~~ 2024-11-12T21:11:44.7123582Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...ewPowerBIReport:NewPowerBIReport) [New-PowerBIReport], Ht tpOperationException 2024-11-12T21:11:44.7151750Z ##[debug] + FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Report s.NewPowerBIReport 2024-11-12T21:11:44.7168896Z ##[debug] 2024-11-12T21:11:44.7193747Z ##[debug]Script stack trace: 2024-11-12T21:11:44.7247194Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1: line 797 2024-11-12T21:11:44.7261850Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1: line 117 2024-11-12T21:11:44.7282584Z ##[debug]at , : line 1 2024-11-12T21:11:44.7307745Z ##[debug]at , : line 22 2024-11-12T21:11:44.7327599Z ##[debug]at , : line 18 2024-11-12T21:11:44.7344988Z ##[debug]at , : line 1 2024-11-12T21:11:44.7370880Z ##[debug]Exception: 2024-11-12T21:11:44.7674427Z ##[debug]Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest' 2024-11-12T21:11:44.7687710Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d8.MoveNext() 2024-11-12T21:11:44.7704566Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2024-11-12T21:11:44.7719082Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2024-11-12T21:11:44.7734557Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2024-11-12T21:11:44.7751620Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d7.MoveNext() 2024-11-12T21:11:44.7767786Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2024-11-12T21:11:44.7782200Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2024-11-12T21:11:44.7796160Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2024-11-12T21:11:44.7810834Z ##[debug] at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport) 2024-11-12T21:11:44.7826312Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict) 2024-11-12T21:11:44.7844890Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout) 2024-11-12T21:11:44.7857591Z ##[debug] at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet() 2024-11-12T21:11:44.7871741Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord() 2024-11-12T21:11:44.8186048Z ##[error]Operation returned an invalid status code 'BadRequest' 2024-11-12T21:11:44.8196355Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'BadRequest' 2024-11-12T21:11:44.8207304Z ##[debug]Processed: ##vso[task.complete result=Failed] 2024-11-12T21:11:44.8535459Z ##[section]Finishing: Publish PowerBI Report

Additional information Installed the same version of the Power BI PowerShell modules (noted that they were behind a bit) locally and authenticated with the service principal and it worked without any issues, so I'm really confused as I had started to assume that it was just a permissions issue.

Also confusing to me is that it can successfully authenticate to find the appropriate workspace.

[luke-barnett]

Here is the pipeline definition:

- task: PowerBIActions@5
  displayName: 'Publish PowerBI Report'
  inputs:
    Action: 'Publish'
    PowerBIServiceEndpoint: ${{ parameters.PowerBIServiceEndpoint }}
    WorkspaceName: ${{ parameters.workspace }}
    PowerBIPath: '$(Pipeline.Workspace)/report/*.pbix'
    Create: false

[maikvandergaag]

Would you mind trying it with setting a reference to one specific report

[luke-barnett]

Updated and ran with the following with the same Bad Request result:

- task: PowerBIActions@5
  displayName: 'Publish PowerBI Report'
  inputs:
    Action: 'Publish'
    PowerBIServiceEndpoint: ${{ parameters.PowerBIServiceEndpoint }}
    WorkspaceName: ${{ parameters.workspace }}
    PowerBIPath: '$(Pipeline.Workspace)/report/report.pbix'
    Create: false

[luke-barnett]

The part I'm keen to know initially is what flags etc. can I set to get some extra detail on what the issue actually is as just a 400 response makes it really hard to decide what direction to try next.

[maikvandergaag]

I understand more information does not come from the unlaying PowerBI Module. Could you share another log file of the last execution?

[luke-barnett]

2024-11-15T01:55:15.9997183Z ##[debug]Evaluating condition for step: 'Publish PowerBI Report' 2024-11-15T01:55:15.9998829Z ##[debug]Evaluating: SucceededNode() 2024-11-15T01:55:15.9999174Z ##[debug]Evaluating SucceededNode: 2024-11-15T01:55:16.0000340Z ##[debug]=> True 2024-11-15T01:55:16.0000691Z ##[debug]Result: True 2024-11-15T01:55:16.0001195Z ##[section]Starting: Publish PowerBI Report 2024-11-15T01:55:16.0028120Z ============================================================================== 2024-11-15T01:55:16.0028432Z Task : Power BI Actions 2024-11-15T01:55:16.0028504Z Description : Release Task Power BI Actions 2024-11-15T01:55:16.0028606Z Version : 5.4.54 2024-11-15T01:55:16.0028671Z Author : Maik van der Gaag 2024-11-15T01:55:16.0029382Z Help : 2024-11-15T01:55:16.0029500Z ============================================================================== 2024-11-15T01:55:17.2481161Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2024-11-15T01:55:17.4883918Z Starting Power BI Actions extension 2024-11-15T01:55:17.5034123Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1. 2024-11-15T01:55:17.5120743Z ### Required Module is needed. Importing now... 2024-11-15T01:55:17.5170917Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2024-11-15T01:55:17.5254938Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2024-11-15T01:55:17.5346450Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2024-11-15T01:55:17.5575901Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2024-11-15T01:55:17.5605793Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2024-11-15T01:55:17.5733601Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2024-11-15T01:55:17.5787423Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2024-11-15T01:55:17.5788613Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2024-11-15T01:55:17.5792759Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2024-11-15T01:55:17.5815232Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2024-11-15T01:55:17.5841188Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2024-11-15T01:55:17.5871515Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2024-11-15T01:55:17.5891334Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2024-11-15T01:55:17.5912566Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2024-11-15T01:55:17.5934611Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2024-11-15T01:55:17.5956744Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2024-11-15T01:55:17.5977581Z ##[debug]Importing alias 'Login-PowerBI'. 2024-11-15T01:55:17.5997024Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2024-11-15T01:55:17.6019771Z ##[debug]Importing alias 'Logout-PowerBI'. 2024-11-15T01:55:17.6040697Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2024-11-15T01:55:17.6060882Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2024-11-15T01:55:17.6079752Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2024-11-15T01:55:17.6119039Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2024-11-15T01:55:17.6198675Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2024-11-15T01:55:17.6434497Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2024-11-15T01:55:17.6466424Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2024-11-15T01:55:17.6578704Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2024-11-15T01:55:17.6598143Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2024-11-15T01:55:17.7850489Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2024-11-15T01:55:17.7855412Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2024-11-15T01:55:17.7886208Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2024-11-15T01:55:17.7933747Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2024-11-15T01:55:17.7938668Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2024-11-15T01:55:17.7962200Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2024-11-15T01:55:17.7985673Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2024-11-15T01:55:17.8007418Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2024-11-15T01:55:17.8027484Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2024-11-15T01:55:17.8043113Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2024-11-15T01:55:17.8067333Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2024-11-15T01:55:17.8089761Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2024-11-15T01:55:17.8108756Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2024-11-15T01:55:17.8112162Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2024-11-15T01:55:17.8134917Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2024-11-15T01:55:17.8165673Z ##[debug]Importing alias 'New-PowerBIGroup'. 2024-11-15T01:55:17.8177869Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2024-11-15T01:55:17.8199018Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2024-11-15T01:55:17.8222884Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2024-11-15T01:55:17.8244125Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2024-11-15T01:55:17.8312665Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2024-11-15T01:55:17.8342256Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2024-11-15T01:55:17.8429313Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2024-11-15T01:55:17.8448080Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2024-11-15T01:55:17.8469640Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2024-11-15T01:55:17.8487942Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2024-11-15T01:55:17.8506637Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2024-11-15T01:55:17.8556865Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2024-11-15T01:55:17.8589879Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2024-11-15T01:55:17.8625833Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2024-11-15T01:55:17.8651093Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2024-11-15T01:55:17.8681823Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2024-11-15T01:55:17.8704185Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2024-11-15T01:55:17.8725016Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2024-11-15T01:55:17.8743247Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2024-11-15T01:55:17.8763497Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2024-11-15T01:55:17.8783922Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2024-11-15T01:55:17.8803212Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2024-11-15T01:55:17.8825731Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2024-11-15T01:55:17.8852082Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2024-11-15T01:55:17.8874089Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2024-11-15T01:55:17.8893872Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2024-11-15T01:55:17.8914963Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2024-11-15T01:55:17.9842213Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2024-11-15T01:55:17.9947481Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2024-11-15T01:55:18.0289769Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2024-11-15T01:55:18.0321746Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2024-11-15T01:55:18.0398264Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2024-11-15T01:55:18.0418068Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2024-11-15T01:55:18.0440129Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2024-11-15T01:55:18.0458245Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2024-11-15T01:55:18.0478452Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2024-11-15T01:55:18.0498872Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2024-11-15T01:55:18.0519723Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2024-11-15T01:55:18.0539542Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2024-11-15T01:55:18.0558140Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2024-11-15T01:55:18.0577806Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2024-11-15T01:55:18.0605029Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2024-11-15T01:55:18.0626732Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2024-11-15T01:55:18.0647076Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2024-11-15T01:55:18.0665592Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2024-11-15T01:55:18.0687480Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2024-11-15T01:55:18.0724545Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2024-11-15T01:55:18.0734737Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2024-11-15T01:55:18.0748719Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2024-11-15T01:55:18.0768272Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2024-11-15T01:55:18.0786893Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2024-11-15T01:55:18.0806017Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2024-11-15T01:55:18.0825300Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2024-11-15T01:55:18.0842206Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2024-11-15T01:55:18.0865989Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2024-11-15T01:55:18.0893228Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2024-11-15T01:55:18.0913353Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2024-11-15T01:55:18.0925370Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2024-11-15T01:55:18.0942419Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2024-11-15T01:55:18.0954285Z ### Trying to import the incorporated module for PowerBI 2024-11-15T01:55:18.0979596Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1'. 2024-11-15T01:55:18.2145646Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2024-11-15T01:55:18.2163828Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2024-11-15T01:55:18.2185820Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2024-11-15T01:55:18.2204509Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2024-11-15T01:55:18.2224972Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2024-11-15T01:55:18.2243460Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2024-11-15T01:55:18.2262805Z ##[debug]Exporting function 'Set-DatasetOwnership'. 2024-11-15T01:55:18.2281209Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'. 2024-11-15T01:55:18.2298530Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2024-11-15T01:55:18.2318394Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2024-11-15T01:55:18.2339582Z ##[debug]Exporting function 'Invoke-API'. 2024-11-15T01:55:18.2359395Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2024-11-15T01:55:18.2377550Z ##[debug]Exporting function 'New-DatasetRefresh'. 2024-11-15T01:55:18.2397236Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2024-11-15T01:55:18.2417947Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2024-11-15T01:55:18.2435709Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2024-11-15T01:55:18.2456133Z ##[debug]Exporting function 'Get-PowerBIReport'. 2024-11-15T01:55:18.2475442Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2024-11-15T01:55:18.2498002Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2024-11-15T01:55:18.2518843Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2024-11-15T01:55:18.2538661Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2024-11-15T01:55:18.2559598Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2024-11-15T01:55:18.2577502Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2024-11-15T01:55:18.2597391Z ##[debug]Exporting function 'Import-PowerBIFile'. 2024-11-15T01:55:18.2616228Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2024-11-15T01:55:18.2635717Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2024-11-15T01:55:18.2656379Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2024-11-15T01:55:18.2675756Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2024-11-15T01:55:18.2695441Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2024-11-15T01:55:18.2714527Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2024-11-15T01:55:18.2757028Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2024-11-15T01:55:18.2774964Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2024-11-15T01:55:18.2783331Z ##[debug]Exporting function 'Set-Capacity'. 2024-11-15T01:55:18.2804332Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2024-11-15T01:55:18.2822975Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2024-11-15T01:55:18.2842380Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2024-11-15T01:55:18.2862806Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2024-11-15T01:55:18.2881226Z ##[debug]Exporting function 'Publish-TabularEditor'. 2024-11-15T01:55:18.2899660Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2024-11-15T01:55:18.2918035Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2024-11-15T01:55:18.2938190Z ##[debug]Exporting function 'Set-PowerBIDatasourceCredentials'. 2024-11-15T01:55:18.2957190Z ##[debug]Exporting function 'Update-DatasourceCredentialsInGateway'. 2024-11-15T01:55:18.2981043Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2024-11-15T01:55:18.2998945Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2024-11-15T01:55:18.3017867Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2024-11-15T01:55:18.3037167Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2024-11-15T01:55:18.3057383Z ##[debug]Importing function 'Get-PowerBICapacity'. 2024-11-15T01:55:18.3075807Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2024-11-15T01:55:18.3092689Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2024-11-15T01:55:18.3111838Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2024-11-15T01:55:18.3131073Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2024-11-15T01:55:18.3148476Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2024-11-15T01:55:18.3165813Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2024-11-15T01:55:18.3182251Z ##[debug]Importing function 'Get-PowerBIGateways'. 2024-11-15T01:55:18.3200207Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2024-11-15T01:55:18.3217611Z ##[debug]Importing function 'Get-PowerBiParameters'. 2024-11-15T01:55:18.3236223Z ##[debug]Importing function 'Get-PowerBIReport'. 2024-11-15T01:55:18.3254554Z ##[debug]Importing function 'Import-PowerBIFile'. 2024-11-15T01:55:18.3271361Z ##[debug]Importing function 'Invoke-API'. 2024-11-15T01:55:18.3290662Z ##[debug]Importing function 'New-DatasetRefresh'. 2024-11-15T01:55:18.3310119Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2024-11-15T01:55:18.3331955Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2024-11-15T01:55:18.3349789Z ##[debug]Importing function 'Publish-PowerBIFile'. 2024-11-15T01:55:18.3368522Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2024-11-15T01:55:18.3384538Z ##[debug]Importing function 'Publish-TabularEditor'. 2024-11-15T01:55:18.3401721Z ##[debug]Importing function 'Redo-PowerBIReport'. 2024-11-15T01:55:18.3435324Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2024-11-15T01:55:18.3459064Z ##[debug]Importing function 'Remove-PowerBIReport'. 2024-11-15T01:55:18.3477411Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2024-11-15T01:55:18.3495464Z ##[debug]Importing function 'Set-Capacity'. 2024-11-15T01:55:18.3514182Z ##[debug]Importing function 'Set-DatasetOwnership'. 2024-11-15T01:55:18.3534135Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'. 2024-11-15T01:55:18.3553197Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2024-11-15T01:55:18.3572990Z ##[debug]Importing function 'Set-PowerBIDatasourceCredentials'. 2024-11-15T01:55:18.3588892Z ##[debug]Importing function 'Set-RefreshSchedule'. 2024-11-15T01:55:18.3612293Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2024-11-15T01:55:18.3629730Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2024-11-15T01:55:18.3649273Z ##[debug]Importing function 'Update-DatasourceCredentialsInGateway'. 2024-11-15T01:55:18.3667667Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2024-11-15T01:55:18.3687134Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2024-11-15T01:55:18.3706879Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2024-11-15T01:55:18.3724693Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2024-11-15T01:55:18.3745444Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2024-11-15T01:55:18.3768058Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2024-11-15T01:55:18.4128158Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '235bbd85-cd97-4572-829f-8c873ba91c9d' 2024-11-15T01:55:18.4266630Z ##[debug]ENDPOINT_URL_235bbd85-cd97-4572-829f-8c873ba91c9d: 'https://api.powerbi.com/v1.0/myorg' 2024-11-15T01:55:18.4290469Z ##[debug]ENDPOINT_AUTH_235bbd85-cd97-4572-829f-8c873ba91c9d: '****' 2024-11-15T01:55:18.4318601Z ##[debug]ENDPOINT_DATA_235bbd85-cd97-4572-829f-8c873ba91c9d: '{"OrganizationType":"Public"}' 2024-11-15T01:55:18.6878346Z ##[debug]{ 2024-11-15T01:55:18.6892028Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2024-11-15T01:55:18.6906858Z ##[debug] "Data": { 2024-11-15T01:55:18.6920496Z ##[debug] "OrganizationType": "Public" 2024-11-15T01:55:18.6935030Z ##[debug] }, 2024-11-15T01:55:18.6948280Z ##[debug] "Auth": { 2024-11-15T01:55:18.6963545Z ##[debug] "parameters": { 2024-11-15T01:55:18.6978690Z ##[debug] "TenantId": "", 2024-11-15T01:55:18.6992085Z ##[debug] "ClientId": "", 2024-11-15T01:55:18.7006260Z ##[debug] "ClientCertificate": "", 2024-11-15T01:55:18.7019233Z ##[debug] "ClientSecret": *** 2024-11-15T01:55:18.7031466Z ##[debug] }, 2024-11-15T01:55:18.7044754Z ##[debug] "scheme": "None" 2024-11-15T01:55:18.7059462Z ##[debug] } 2024-11-15T01:55:18.7075299Z ##[debug]} 2024-11-15T01:55:19.3521404Z ##[debug]1:55:19 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2024-11-15T01:55:19.3545092Z ##[debug]1:55:19 AM - Cmdlet version: 1.2.1077.0 2024-11-15T01:55:19.3909011Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/94260f03-0793-484a-91cf-bebe584319bc 2024-11-15T01:55:19.5792243Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19] Found 0 cache accounts and 0 broker accounts 2024-11-15T01:55:19.5875303Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(9b54c14f-1fe5-4aba-a474-ba8316ffbb54) 2024-11-15T01:55:19.5910082Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === AcquireTokenForClientParameters === 2024-11-15T01:55:19.5926439Z ##[debug]SendX5C: False 2024-11-15T01:55:19.5940177Z ##[debug]WithAzureRegion: False 2024-11-15T01:55:19.5956555Z ##[debug]RegionToUse: 2024-11-15T01:55:19.5974773Z ##[debug]ForceRefresh: False 2024-11-15T01:55:19.5989787Z ##[debug] 2024-11-15T01:55:19.6136912Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] 2024-11-15T01:55:19.6151077Z ##[debug]=== Request Data === 2024-11-15T01:55:19.6165255Z ##[debug]Authority Provided? - True 2024-11-15T01:55:19.6179818Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-15T01:55:19.6192942Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-15T01:55:19.6207219Z ##[debug]ApiId - AcquireTokenForClient 2024-11-15T01:55:19.6223324Z ##[debug]IsConfidentialClient - True 2024-11-15T01:55:19.6236823Z ##[debug]SendX5C - False 2024-11-15T01:55:19.6251566Z ##[debug]LoginHint ? False 2024-11-15T01:55:19.6266907Z ##[debug]IsBrokerConfigured - False 2024-11-15T01:55:19.6283191Z ##[debug]HomeAccountId - False 2024-11-15T01:55:19.6296234Z ##[debug]CorrelationId - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54 2024-11-15T01:55:19.6310372Z ##[debug] 2024-11-15T01:55:19.6342425Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === Token Acquisition (ClientCredentialRequest) started: 2024-11-15T01:55:19.6356698Z ##[debug]
2024-11-15T01:55:19.6370683Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-15T01:55:19.6745706Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Fetching instance discovery from the network from host login.microsoftonline.com. 2024-11-15T01:55:20.1932953Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Resolving authority endpoints... Already resolved? - FALSE 2024-11-15T01:55:20.1953498Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2024-11-15T01:55:20.1974109Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Checking client info returned from the server.. 2024-11-15T01:55:20.1998184Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Saving Token Response to cache.. 2024-11-15T01:55:20.2019418Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] ID Token not present in response. 2024-11-15T01:55:20.2070414Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Saving AT in cache and removing overlapping ATs... 2024-11-15T01:55:20.2071910Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2024-11-15T01:55:20.2088584Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Intersecting scope entries count - 0 2024-11-15T01:55:20.2097345Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 === 2024-11-15T01:55:20.2118855Z ##[debug]1:55:20 AM - Connect-PowerBIServiceAccount end processing. 2024-11-15T01:55:20.2149999Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\report\report.pbix' 2024-11-15T01:55:20.2482838Z ##[debug]INPUT_WORKSPACENAME: 'dev' 2024-11-15T01:55:20.2507576Z ##[debug]INPUT_OVERWRITE: 'true' 2024-11-15T01:55:20.2550256Z ##[debug] Converted to bool: True 2024-11-15T01:55:20.2576347Z ##[debug]INPUT_CREATE: 'false' 2024-11-15T01:55:20.2597902Z ##[debug] Converted to bool: False 2024-11-15T01:55:20.2627401Z ##[debug]INPUT_ACTION: 'Publish' 2024-11-15T01:55:20.2652689Z ##[debug]INPUT_DATASETNAME (empty) 2024-11-15T01:55:20.2703996Z ##[debug]INPUT_OLDURL (empty) 2024-11-15T01:55:20.2730108Z ##[debug]INPUT_NEWURL (empty) 2024-11-15T01:55:20.2756410Z ##[debug]INPUT_OLDSERVER (empty) 2024-11-15T01:55:20.2788094Z ##[debug]INPUT_NEWSERVER (empty) 2024-11-15T01:55:20.2815038Z ##[debug]INPUT_OLDDATABASE (empty) 2024-11-15T01:55:20.2842418Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2024-11-15T01:55:20.2869607Z ##[debug]INPUT_NEWDATABASE (empty) 2024-11-15T01:55:20.2898698Z ##[debug]INPUT_PERMISSION (empty) 2024-11-15T01:55:20.2925028Z ##[debug]INPUT_USERS (empty) 2024-11-15T01:55:20.2952989Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2024-11-15T01:55:20.2980374Z ##[debug]INPUT_UPDATEALL: 'false' 2024-11-15T01:55:20.3002843Z ##[debug] Converted to bool: False 2024-11-15T01:55:20.3029150Z ##[debug]INPUT_SKIPREPORT: 'false' 2024-11-15T01:55:20.3049217Z ##[debug] Converted to bool: False 2024-11-15T01:55:20.3075760Z ##[debug]INPUT_SCOPE: 'Private' 2024-11-15T01:55:20.3105273Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2024-11-15T01:55:20.3130182Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2024-11-15T01:55:20.3156558Z ##[debug]INPUT_PARAMETERINPUT (empty) 2024-11-15T01:55:20.3183338Z ##[debug]INPUT_GATEWAYNAME (empty) 2024-11-15T01:55:20.3210543Z ##[debug]INPUT_REPORTNAME (empty) 2024-11-15T01:55:20.3237035Z ##[debug]INPUT_CAPACITYNAME (empty) 2024-11-15T01:55:20.3264356Z ##[debug]INPUT_USERNAME (empty) 2024-11-15T01:55:20.3291022Z ##[debug]INPUT_PASSWORD (empty) 2024-11-15T01:55:20.4129828Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2024-11-15T01:55:20.4132092Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2024-11-15T01:55:20.4164766Z ##[debug] Converted to bool: False 2024-11-15T01:55:20.4189798Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2024-11-15T01:55:20.4282266Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2024-11-15T01:55:20.4307355Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2024-11-15T01:55:20.4332763Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2024-11-15T01:55:20.4355521Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2024-11-15T01:55:20.4381069Z ##[debug]INPUT_DATASETACCESSRIGHT (empty) 2024-11-15T01:55:20.4403829Z ##[debug]INPUT_SERVER (empty) 2024-11-15T01:55:20.4428648Z ##[debug]INPUT_DATABASE (empty) 2024-11-15T01:55:20.4451247Z ##[debug]INPUT_TENANTID (empty) 2024-11-15T01:55:20.4474706Z ##[debug]INPUT_SERVICEPRINCIPALID (empty) 2024-11-15T01:55:20.4477670Z ##[debug]INPUT_SERVICEPRINCIPALKEY (empty) 2024-11-15T01:55:20.4506042Z ##[debug]WorkspaceName : dev 2024-11-15T01:55:20.4528144Z ##[debug]Create : False 2024-11-15T01:55:20.4547124Z ##[debug]File patern : D:\a\1\report\report.pbix 2024-11-15T01:55:20.4567386Z ##[debug]Remove report : False 2024-11-15T01:55:20.4754403Z Getting Power BI Workspace properties; dev 2024-11-15T01:55:20.4816047Z ##[debug]1:55:20 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2024-11-15T01:55:20.4840714Z ##[debug]1:55:20 AM - Cmdlet version: 1.2.1077.0 2024-11-15T01:55:20.5494695Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20] Found 0 cache accounts and 0 broker accounts 2024-11-15T01:55:20.5516138Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(c64b1495-61d0-4b14-a0f0-06f124f8e3ea) 2024-11-15T01:55:20.5537060Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === AcquireTokenForClientParameters === 2024-11-15T01:55:20.5551471Z ##[debug]SendX5C: False 2024-11-15T01:55:20.5565864Z ##[debug]WithAzureRegion: False 2024-11-15T01:55:20.5580800Z ##[debug]RegionToUse: 2024-11-15T01:55:20.5594349Z ##[debug]ForceRefresh: False 2024-11-15T01:55:20.5609162Z ##[debug] 2024-11-15T01:55:20.5631448Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] 2024-11-15T01:55:20.5646141Z ##[debug]=== Request Data === 2024-11-15T01:55:20.5660303Z ##[debug]Authority Provided? - True 2024-11-15T01:55:20.5676181Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-15T01:55:20.5692682Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-15T01:55:20.5707698Z ##[debug]ApiId - AcquireTokenForClient 2024-11-15T01:55:20.5722948Z ##[debug]IsConfidentialClient - True 2024-11-15T01:55:20.5739477Z ##[debug]SendX5C - False 2024-11-15T01:55:20.5754033Z ##[debug]LoginHint ? False 2024-11-15T01:55:20.5771443Z ##[debug]IsBrokerConfigured - False 2024-11-15T01:55:20.5797484Z ##[debug]HomeAccountId - False 2024-11-15T01:55:20.5816008Z ##[debug]CorrelationId - c64b1495-61d0-4b14-a0f0-06f124f8e3ea 2024-11-15T01:55:20.5828848Z ##[debug] 2024-11-15T01:55:20.5853416Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === Token Acquisition (ClientCredentialRequest) started: 2024-11-15T01:55:20.5867580Z ##[debug]
2024-11-15T01:55:20.5882582Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-15T01:55:20.5948647Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:20) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)] 2024-11-15T01:55:20.5979048Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 === 2024-11-15T01:55:21.6535713Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'dev'&$top=100 2024-11-15T01:55:21.6552917Z ##[debug]Status Code: OK (200) 2024-11-15T01:55:21.6574071Z ##[debug]1:55:21 AM - Get-PowerBIWorkspace end processing. 2024-11-15T01:55:21.6641285Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]b13833a5-3cff-4582-9c20-b1898fa06718 2024-11-15T01:55:21.6664333Z ##[debug]1:55:21 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2024-11-15T01:55:21.6717098Z ##[debug]1:55:21 AM - Cmdlet version: 1.2.1077.0 2024-11-15T01:55:21.6738571Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21] Found 0 cache accounts and 0 broker accounts 2024-11-15T01:55:21.6757530Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(3429cdfc-05d3-4186-bc63-2baad82254d2) 2024-11-15T01:55:21.6780011Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === AcquireTokenForClientParameters === 2024-11-15T01:55:21.6793288Z ##[debug]SendX5C: False 2024-11-15T01:55:21.6805683Z ##[debug]WithAzureRegion: False 2024-11-15T01:55:21.6821593Z ##[debug]RegionToUse: 2024-11-15T01:55:21.6837624Z ##[debug]ForceRefresh: False 2024-11-15T01:55:21.6850325Z ##[debug] 2024-11-15T01:55:21.6871071Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] 2024-11-15T01:55:21.6887225Z ##[debug]=== Request Data === 2024-11-15T01:55:21.6899048Z ##[debug]Authority Provided? - True 2024-11-15T01:55:21.6911112Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-15T01:55:21.6925825Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-15T01:55:21.6939260Z ##[debug]ApiId - AcquireTokenForClient 2024-11-15T01:55:21.6951789Z ##[debug]IsConfidentialClient - True 2024-11-15T01:55:21.6965161Z ##[debug]SendX5C - False 2024-11-15T01:55:21.6980686Z ##[debug]LoginHint ? False 2024-11-15T01:55:21.6995927Z ##[debug]IsBrokerConfigured - False 2024-11-15T01:55:21.7008414Z ##[debug]HomeAccountId - False 2024-11-15T01:55:21.7020449Z ##[debug]Agent environment resources - Disk: D:\ Available 12446.73 MB out of 14334.00 MB, Memory: Used 2087.00 MB out of 7167.00 MB, CPU: Usage 75.00% 2024-11-15T01:55:21.7031960Z ##[debug]CorrelationId - 3429cdfc-05d3-4186-bc63-2baad82254d2 2024-11-15T01:55:21.7033731Z ##[debug] 2024-11-15T01:55:21.7052336Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === Token Acquisition (ClientCredentialRequest) started: 2024-11-15T01:55:21.7065560Z ##[debug]
2024-11-15T01:55:21.7081667Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-15T01:55:21.7102071Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:21) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)] 2024-11-15T01:55:21.7121468Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 === 2024-11-15T01:55:22.3035338Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'dev'&$top=100 2024-11-15T01:55:22.3053075Z ##[debug]Status Code: OK (200) 2024-11-15T01:55:22.3071716Z ##[debug]1:55:22 AM - Get-PowerBIWorkspace end processing. 2024-11-15T01:55:22.3150747Z Trying to publish PowerBI File: D:\a\1\report\report.pbix 2024-11-15T01:55:22.3199996Z Checking for existing Reports with the name: report 2024-11-15T01:55:22.3280813Z ##[debug]1:55:22 AM - New-PowerBIReport begin processing with ParameterSet Workspace. 2024-11-15T01:55:22.3302014Z ##[debug]1:55:22 AM - Cmdlet version: 1.2.1077.0 2024-11-15T01:55:22.3335050Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22] Found 0 cache accounts and 0 broker accounts 2024-11-15T01:55:22.3356635Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4160b268-0023-4fb2-8c12-810119ac372b) 2024-11-15T01:55:22.3380170Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === AcquireTokenForClientParameters === 2024-11-15T01:55:22.3394023Z ##[debug]SendX5C: False 2024-11-15T01:55:22.3407360Z ##[debug]WithAzureRegion: False 2024-11-15T01:55:22.3420860Z ##[debug]RegionToUse: 2024-11-15T01:55:22.3436741Z ##[debug]ForceRefresh: False 2024-11-15T01:55:22.3451044Z ##[debug] 2024-11-15T01:55:22.3473946Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] 2024-11-15T01:55:22.3489964Z ##[debug]=== Request Data === 2024-11-15T01:55:22.3506083Z ##[debug]Authority Provided? - True 2024-11-15T01:55:22.3522304Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2024-11-15T01:55:22.4209265Z ##[debug]Extra Query Params Keys (space separated) - 2024-11-15T01:55:22.4225326Z ##[debug]ApiId - AcquireTokenForClient 2024-11-15T01:55:22.4242734Z ##[debug]IsConfidentialClient - True 2024-11-15T01:55:22.4255711Z ##[debug]SendX5C - False 2024-11-15T01:55:22.4269766Z ##[debug]LoginHint ? False 2024-11-15T01:55:22.4284808Z ##[debug]IsBrokerConfigured - False 2024-11-15T01:55:22.4300481Z ##[debug]HomeAccountId - False 2024-11-15T01:55:22.4314078Z ##[debug]CorrelationId - 4160b268-0023-4fb2-8c12-810119ac372b 2024-11-15T01:55:22.4328685Z ##[debug] 2024-11-15T01:55:22.4350845Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === Token Acquisition (ClientCredentialRequest) started: 2024-11-15T01:55:22.4364218Z ##[debug]
2024-11-15T01:55:22.4377028Z ##[debug] Authority Host: login.microsoftonline.com 2024-11-15T01:55:22.4401480Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:22) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)] 2024-11-15T01:55:22.4420307Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 === 2024-11-15T01:55:23.2355104Z Done processing Power BI Actions 2024-11-15T01:55:23.2994693Z ##[debug]Caught exception from task script. 2024-11-15T01:55:23.3031870Z ##[debug]Error record: 2024-11-15T01:55:23.3658323Z ##[debug]New-PowerBIReport : Operation returned an invalid status code 'BadRequest' 2024-11-15T01:55:23.3675844Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1:797 char:27 2024-11-15T01:55:23.3690565Z ##[debug]+ ... $report = New-PowerBIReport -Path $filePath -Name $fileToPublish -W ... 2024-11-15T01:55:23.3704440Z ##[debug]+ ~~~~~~~~~~~~~ 2024-11-15T01:55:23.3721123Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...ewPowerBIReport:NewPowerBIReport) [New-PowerBIReport], Ht tpOperationException 2024-11-15T01:55:23.3735457Z ##[debug] + FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Report s.NewPowerBIReport 2024-11-15T01:55:23.3748945Z ##[debug] 2024-11-15T01:55:23.3770476Z ##[debug]Script stack trace: 2024-11-15T01:55:23.3820819Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1: line 797 2024-11-15T01:55:23.3838760Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1: line 117 2024-11-15T01:55:23.3856665Z ##[debug]at , : line 1 2024-11-15T01:55:23.3871233Z ##[debug]at , : line 22 2024-11-15T01:55:23.3885528Z ##[debug]at , : line 18 2024-11-15T01:55:23.3901084Z ##[debug]at , : line 1 2024-11-15T01:55:23.3924890Z ##[debug]Exception: 2024-11-15T01:55:23.4157588Z ##[debug]Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest' 2024-11-15T01:55:23.4173079Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d8.MoveNext() 2024-11-15T01:55:23.4188730Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2024-11-15T01:55:23.4201927Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2024-11-15T01:55:23.4217037Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2024-11-15T01:55:23.4232149Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d7.MoveNext() 2024-11-15T01:55:23.4246148Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2024-11-15T01:55:23.4259347Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2024-11-15T01:55:23.4273554Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2024-11-15T01:55:23.4288278Z ##[debug] at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport) 2024-11-15T01:55:23.4304243Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict) 2024-11-15T01:55:23.4320130Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout) 2024-11-15T01:55:23.4333744Z ##[debug] at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet() 2024-11-15T01:55:23.4346666Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord() 2024-11-15T01:55:23.4620221Z ##[error]Operation returned an invalid status code 'BadRequest' 2024-11-15T01:55:23.4628799Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'BadRequest' 2024-11-15T01:55:23.4638014Z ##[debug]Processed: ##vso[task.complete result=Failed] 2024-11-15T01:55:23.4943287Z ##[section]Finishing: Publish PowerBI Report