search

maikvandergaag / msft-extensions

Repository for extensions mainly used for Azure DevOps Extensions
https://msftplayground.com
MIT License
126 stars 81 forks source link

Getting Operation returned an invalid status code 'BadRequest' while trying to publish .pbix #439

Closed hbhansal closed 1 year ago

hbhansal commented 1 year ago

Describe the issue While trying to upload .pbix reports to a workspace we get the following error : Operation returned an invalid status code 'BadRequest'

Extension

To Reproduce Steps to reproduce the behavior:

  1. Go to the CD pipeline
  2. Click deploy reports, with .pbix extension
  3. Scroll down to the power BI task
  4. See error

Expected behavior .pbix report should get uploaded/published

Situation (please complete the following information):

Log info 2022-09-16T17:08:51.8206754Z ##[debug]Evaluating condition for step: 'PowerBIActions' 2022-09-16T17:08:51.8210041Z ##[debug]Evaluating: SucceededNode() 2022-09-16T17:08:51.8210912Z ##[debug]Evaluating SucceededNode: 2022-09-16T17:08:51.8212623Z ##[debug]=> True 2022-09-16T17:08:51.8213527Z ##[debug]Result: True 2022-09-16T17:08:51.8214326Z ##[section]Starting: PowerBIActions 2022-09-16T17:08:51.8545024Z ============================================================================== 2022-09-16T17:08:51.8545486Z Task : Power BI Actions 2022-09-16T17:08:51.8545842Z Description : Release Task Power BI Actions 2022-09-16T17:08:51.8546143Z Version : 5.4.39 2022-09-16T17:08:51.8546439Z Author : Maik van der Gaag 2022-09-16T17:08:51.8546730Z Help : 2022-09-16T17:08:51.8547064Z ============================================================================== 2022-09-16T17:08:53.2133559Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2022-09-16T17:08:53.7393944Z Starting Power BI Actions extension 2022-09-16T17:08:53.7539447Z ##[debug]Entering C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-09-16T17:08:53.7630049Z ### Required Module is needed. Importing now... 2022-09-16T17:08:53.7722632Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2022-09-16T17:08:53.7829697Z ##[debug]Loading 'TypesToProcess' from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2022-09-16T17:08:53.7982202Z ##[debug]Loading 'FormatsToProcess' from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2022-09-16T17:08:53.8437498Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2022-09-16T17:08:53.8507991Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2022-09-16T17:08:53.8707000Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-16T17:08:53.8855621Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-16T17:08:53.8887586Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2022-09-16T17:08:53.8924187Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-16T17:08:53.8960135Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2022-09-16T17:08:53.8996347Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-16T17:08:53.9157391Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-16T17:08:53.9218386Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2022-09-16T17:08:53.9266063Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-16T17:08:53.9272429Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2022-09-16T17:08:53.9325627Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2022-09-16T17:08:53.9438781Z ##[debug]Importing alias 'Login-PowerBI'. 2022-09-16T17:08:53.9488036Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2022-09-16T17:08:53.9494547Z ##[debug]Importing alias 'Logout-PowerBI'. 2022-09-16T17:08:53.9549322Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2022-09-16T17:08:53.9648894Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2022-09-16T17:08:53.9699850Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2022-09-16T17:08:53.9739255Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2022-09-16T17:08:53.9950573Z ##[debug]Loading 'FormatsToProcess' from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2022-09-16T17:08:54.0464774Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2022-09-16T17:08:54.0542098Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2022-09-16T17:08:54.0724883Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-16T17:08:54.1063667Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2022-09-16T17:08:54.1219983Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-16T17:08:54.1993497Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2022-09-16T17:08:54.3936982Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-16T17:08:54.4009858Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2022-09-16T17:08:54.4073023Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2022-09-16T17:08:54.4179501Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-16T17:08:54.4339562Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2022-09-16T17:08:54.4400050Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-16T17:08:54.4450589Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2022-09-16T17:08:54.4500002Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-16T17:08:54.4549741Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2022-09-16T17:08:54.4603670Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2022-09-16T17:08:54.4682396Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2022-09-16T17:08:54.4719740Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2022-09-16T17:08:54.4759082Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2022-09-16T17:08:54.4898483Z ##[debug]Importing alias 'New-PowerBIGroup'. 2022-09-16T17:08:54.4909151Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2022-09-16T17:08:54.4962765Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2022-09-16T17:08:54.4997057Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2022-09-16T17:08:54.5070928Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2022-09-16T17:08:54.5235526Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2022-09-16T17:08:54.5308312Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2022-09-16T17:08:54.5497970Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2022-09-16T17:08:54.5512475Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2022-09-16T17:08:54.5567792Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2022-09-16T17:08:54.5633285Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2022-09-16T17:08:54.5720451Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2022-09-16T17:08:54.5768481Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2022-09-16T17:08:54.5816065Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2022-09-16T17:08:54.5863549Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2022-09-16T17:08:54.5910245Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2022-09-16T17:08:54.5949203Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2022-09-16T17:08:54.5987909Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2022-09-16T17:08:54.6025384Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2022-09-16T17:08:54.6066863Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2022-09-16T17:08:54.6108546Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2022-09-16T17:08:54.6360598Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2022-09-16T17:08:54.6408310Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2022-09-16T17:08:54.6455340Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2022-09-16T17:08:54.6507105Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2022-09-16T17:08:54.6551772Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2022-09-16T17:08:54.6598709Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2022-09-16T17:08:54.6645149Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2022-09-16T17:08:54.6729237Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2022-09-16T17:08:54.6902036Z ##[debug]Loading 'FormatsToProcess' from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2022-09-16T17:08:54.7373835Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2022-09-16T17:08:54.7421123Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2022-09-16T17:08:54.7513344Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2022-09-16T17:08:54.7550039Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2022-09-16T17:08:54.7583518Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2022-09-16T17:08:54.7618686Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2022-09-16T17:08:54.7652240Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-16T17:08:54.7685058Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2022-09-16T17:08:54.7721157Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2022-09-16T17:08:54.7755912Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2022-09-16T17:08:54.7796739Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2022-09-16T17:08:54.7829476Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2022-09-16T17:08:54.7866341Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2022-09-16T17:08:54.7899609Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2022-09-16T17:08:54.7932487Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2022-09-16T17:08:54.7972277Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2022-09-16T17:08:54.8007233Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2022-09-16T17:08:54.8043818Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2022-09-16T17:08:54.8080749Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2022-09-16T17:08:54.8163553Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2022-09-16T17:08:54.8168722Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-16T17:08:54.8201869Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2022-09-16T17:08:54.8244561Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2022-09-16T17:08:54.8291838Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2022-09-16T17:08:54.8330858Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2022-09-16T17:08:54.8363352Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2022-09-16T17:08:54.8399562Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2022-09-16T17:08:54.8444586Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2022-09-16T17:08:54.8477596Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2022-09-16T17:08:54.8510003Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2022-09-16T17:08:54.8529075Z ### Trying to import the incorporated module for PowerBI 2022-09-16T17:08:54.8630528Z ##[debug]Loading module from path 'C:\agent_work_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'. 2022-09-16T17:08:54.8927668Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-16T17:08:54.8966528Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-16T17:08:54.9001573Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2022-09-16T17:08:54.9034958Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-16T17:08:54.9076876Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2022-09-16T17:08:54.9110580Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2022-09-16T17:08:54.9143875Z ##[debug]Exporting function 'Set-DatasetOwnership'. 2022-09-16T17:08:54.9177096Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'. 2022-09-16T17:08:54.9210939Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2022-09-16T17:08:54.9247098Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2022-09-16T17:08:54.9280298Z ##[debug]Exporting function 'Invoke-API'. 2022-09-16T17:08:54.9316297Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2022-09-16T17:08:54.9348465Z ##[debug]Exporting function 'New-DatasetRefresh'. 2022-09-16T17:08:54.9388924Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2022-09-16T17:08:54.9421768Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2022-09-16T17:08:54.9455661Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2022-09-16T17:08:54.9487997Z ##[debug]Exporting function 'Get-PowerBIReport'. 2022-09-16T17:08:54.9521488Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2022-09-16T17:08:54.9556964Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2022-09-16T17:08:54.9589964Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2022-09-16T17:08:54.9622939Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2022-09-16T17:08:54.9658291Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2022-09-16T17:08:55.0132336Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2022-09-16T17:08:55.0184503Z ##[debug]Exporting function 'Import-PowerBIFile'. 2022-09-16T17:08:55.0229024Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2022-09-16T17:08:55.0271942Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2022-09-16T17:08:55.0315421Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2022-09-16T17:08:55.0360577Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2022-09-16T17:08:55.0403600Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2022-09-16T17:08:55.0446646Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2022-09-16T17:08:55.0489733Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2022-09-16T17:08:55.0523494Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2022-09-16T17:08:55.0559743Z ##[debug]Exporting function 'Set-Capacity'. 2022-09-16T17:08:55.0592811Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2022-09-16T17:08:55.0626207Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-16T17:08:55.0659795Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2022-09-16T17:08:55.0692340Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2022-09-16T17:08:55.0727573Z ##[debug]Exporting function 'Publish-TabularEditor'. 2022-09-16T17:08:55.0760414Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2022-09-16T17:08:55.0794025Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2022-09-16T17:08:55.0835315Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2022-09-16T17:08:55.0869908Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2022-09-16T17:08:55.0903173Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2022-09-16T17:08:55.0953007Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2022-09-16T17:08:55.0987014Z ##[debug]Importing function 'Get-PowerBICapacity'. 2022-09-16T17:08:55.1021610Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2022-09-16T17:08:55.1057430Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2022-09-16T17:08:55.1090228Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-16T17:08:55.1160919Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2022-09-16T17:08:55.1195040Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2022-09-16T17:08:55.1229587Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2022-09-16T17:08:55.1262268Z ##[debug]Importing function 'Get-PowerBIGateways'. 2022-09-16T17:08:55.1301427Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2022-09-16T17:08:55.1334641Z ##[debug]Importing function 'Get-PowerBiParameters'. 2022-09-16T17:08:55.1367188Z ##[debug]Importing function 'Get-PowerBIReport'. 2022-09-16T17:08:55.1402127Z ##[debug]Importing function 'Import-PowerBIFile'. 2022-09-16T17:08:55.1440524Z ##[debug]Importing function 'Invoke-API'. 2022-09-16T17:08:55.1485994Z ##[debug]Importing function 'New-DatasetRefresh'. 2022-09-16T17:08:55.1534442Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2022-09-16T17:08:55.1582851Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2022-09-16T17:08:55.1669582Z ##[debug]Importing function 'Publish-PowerBIFile'. 2022-09-16T17:08:55.1677212Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2022-09-16T17:08:55.1722970Z ##[debug]Importing function 'Publish-TabularEditor'. 2022-09-16T17:08:55.1759618Z ##[debug]Importing function 'Redo-PowerBIReport'. 2022-09-16T17:08:55.1797536Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-16T17:08:55.1829914Z ##[debug]Importing function 'Remove-PowerBIReport'. 2022-09-16T17:08:55.1862394Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2022-09-16T17:08:55.1896725Z ##[debug]Importing function 'Set-Capacity'. 2022-09-16T17:08:55.1929201Z ##[debug]Importing function 'Set-DatasetOwnership'. 2022-09-16T17:08:55.1964815Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'. 2022-09-16T17:08:55.2001751Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-16T17:08:55.2042113Z ##[debug]Importing function 'Set-RefreshSchedule'. 2022-09-16T17:08:55.2076950Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2022-09-16T17:08:55.2131276Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2022-09-16T17:08:55.2172665Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2022-09-16T17:08:55.2206804Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2022-09-16T17:08:55.2239364Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-16T17:08:55.2273555Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2022-09-16T17:08:55.2308317Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2022-09-16T17:08:55.2342300Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. https://api.powerbi.com/v1.0/myorg' {"OrganizationType":"Public"}' 2022-09-16T17:08:55.3109409Z ##[debug]{ 2022-09-16T17:08:55.3153281Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2022-09-16T17:08:55.5718158Z ##[debug]5:08:55 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2022-09-16T17:08:55.5762730Z ##[debug]5:08:55 PM - Cmdlet version: 1.2.1077.0 2022-09-16T17:08:55.6236795Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: 2022-09-16T17:08:55.7240652Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [09/16/2022 17:08:55] Found 0 cache accounts and 0 broker accounts 2022-09-16T17:08:55.7332511Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [09/16/2022 17:08:55 - d476b203-e3d8-436b-8dea-87a664388261] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(d476b203-e3d8-436b-8dea-87a664388261) 2022-09-16T17:08:55.7382422Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 2022-09-16T17:08:55.7411282Z ##[debug]SendX5C: False 2022-09-16T17:08:55.7442707Z ##[debug]WithAzureRegion: False 2022-09-16T17:08:55.7505063Z ##[debug]RegionToUse: 2022-09-16T17:08:55.7570281Z ##[debug]ForceRefresh: False 2022-09-16T17:08:55.7685004Z ##[debug] 2022-09-16T17:08:55.7972712Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 2022-09-16T17:08:55.8009331Z ##[debug]=== Request Data === 2022-09-16T17:08:55.8042704Z ##[debug]Authority Provided? - True 2022-09-16T17:08:55.8081295Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-16T17:08:55.8110659Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-16T17:08:55.8140457Z ##[debug]ApiId - AcquireTokenForClient 2022-09-16T17:08:55.8201543Z ##[debug]IsConfidentialClient - True 2022-09-16T17:08:55.8218574Z ##[debug]SendX5C - False 2022-09-16T17:08:55.8236639Z ##[debug]LoginHint ? False 2022-09-16T17:08:55.8267895Z ##[debug]IsBrokerConfigured - False 2022-09-16T17:08:55.8293367Z ##[debug]HomeAccountId - False 2022-09-16T17:08:55.8353931Z ##[debug] 2022-09-16T17:08:55.8475107Z ##[debug]
2022-09-16T17:08:55.8500226Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-16T17:08:55.8870087Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [09/16/2022 17:08:55 - d476b203-e3d8-436b-8dea-87a664388261] Fetching instance discovery from the network from host login.microsoftonline.com. 2022-09-16T17:08:56.6982813Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [09/16/2022 17:08:56 - d476b203-e3d8-436b-8dea-87a664388261] Resolving authority endpoints... Already resolved? - FALSE 2022-09-16T17:08:58.9006562Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2022-09-16T17:08:58.9029153Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2022-09-16T17:08:58.9051915Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2022-09-16T17:08:58.9101807Z ##[debug] at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport) 2022-09-16T17:08:58.9126128Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict) 2022-09-16T17:08:58.9149309Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout) 2022-09-16T17:08:58.9171946Z ##[debug] at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet() 2022-09-16T17:08:58.9194754Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord() 2022-09-16T17:08:58.9494785Z ##[error]Operation returned an invalid status code 'BadRequest' 2022-09-16T17:08:58.9509262Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'BadRequest' 2022-09-16T17:08:58.9519602Z ##[debug]Processed: ##vso[task.complete result=Failed] 2022-09-16T17:08:58.9989925Z ##[section]Finishing: PowerBIActions

Additional information Reports do not get deployed, even tried creating a new workspace to deploy from scratch but did not work.

maikvandergaag commented 1 year ago

Thanks for the detailed information. Few questions:

hbhansal commented 1 year ago
maikvandergaag commented 1 year ago

Ok,

Would you mind trying to deploy it with the Microsoft Power BI Module?

hbhansal commented 1 year ago

Is there a reference which you could help me out with? Also, a strange observation that I notice, the first report goes through without any issues, the subsequent ones fail. Is there a reason why this could be happening?

maikvandergaag commented 1 year ago

No that seems strange. Can be that something is wrong with the report that is not fully supported.

https://learn.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.reports/new-powerbireport?view=powerbi-ps

hbhansal commented 1 year ago

Is there any way we can get a better error results? In diagnostics I see that the error is 2022-09-16T17:08:58.9126128Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict) 2022-09-16T17:08:58.9149309Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout)

maikvandergaag commented 1 year ago

The way you can test is performing the scripts from your local system.

maikvandergaag commented 1 year ago

Did you get it to work by testing it locally?

maikvandergaag commented 1 year ago

Closed because off a long period with no response