search

maikvandergaag / msft-extensions

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

Operation returned as Invalid status code 'Unauthorized' #460

Closed Pass1406 closed 1 year ago

Pass1406 commented 1 year ago

Describe the issue Hi @maikvandergaag i m configuring CICD for power bi reports using power bi actions extension to upload pbix file into a given workspace using service principal for authentication. After i deployed using release im getting an error as ' Operation returned as Invalid status code 'Unauthorized'.

Steps which i followed are as...

Extension

Expected behavior

Log info 2022-12-07T06:59:28.8112605Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish' 2022-12-07T06:59:28.8114875Z ##[debug]Evaluating: succeeded() 2022-12-07T06:59:28.8115414Z ##[debug]Evaluating succeeded: 2022-12-07T06:59:28.8116843Z ##[debug]=> True 2022-12-07T06:59:28.8117422Z ##[debug]Result: True 2022-12-07T06:59:28.8117968Z ##[section]Starting: Power BI Action: Publish 2022-12-07T06:59:28.8241650Z ============================================================================== 2022-12-07T06:59:28.8241957Z Task : Power BI Actions 2022-12-07T06:59:28.8242197Z Description : Release Task Power BI Actions 2022-12-07T06:59:28.8242394Z Version : 5.4.39 2022-12-07T06:59:28.8242590Z Author : Maik van der Gaag 2022-12-07T06:59:28.8242762Z Help : 2022-12-07T06:59:28.8243010Z ============================================================================== 2022-12-07T06:59:30.4437498Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2022-12-07T06:59:30.6337876Z Starting Power BI Actions extension 2022-12-07T06:59:30.6450615Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-12-07T06:59:30.6515889Z ### Required Module is needed. Importing now... 2022-12-07T06:59:30.6553699Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2022-12-07T06:59:30.6678251Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2022-12-07T06:59:30.6764068Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2022-12-07T06:59:30.7043265Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2022-12-07T06:59:30.7069332Z ##[debug]Loading module from path 'D:\a_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-12-07T06:59:30.7270251Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2022-12-07T06:59:30.7315523Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-12-07T06:59:30.7316893Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2022-12-07T06:59:30.7321290Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2022-12-07T06:59:30.7336038Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2022-12-07T06:59:30.7351826Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2022-12-07T06:59:30.7367044Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-12-07T06:59:30.7382147Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2022-12-07T06:59:30.7397179Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2022-12-07T06:59:30.7413439Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2022-12-07T06:59:30.7428442Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2022-12-07T06:59:30.7444258Z ##[debug]Importing alias 'Login-PowerBI'. 2022-12-07T06:59:30.7459882Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2022-12-07T06:59:30.7475031Z ##[debug]Importing alias 'Logout-PowerBI'. 2022-12-07T06:59:30.7490318Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2022-12-07T06:59:30.7504937Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2022-12-07T06:59:30.7520538Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2022-12-07T06:59:30.7551968Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2022-12-07T06:59:30.7611306Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2022-12-07T06:59:30.7812085Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2022-12-07T06:59:30.7850450Z ##[debug]Loading module from path 'D:\a_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-12-07T06:59:30.7924165Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2022-12-07T06:59:30.7952426Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2022-12-07T06:59:30.7987920Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-12-07T06:59:30.8271895Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2022-12-07T06:59:30.8973404Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-12-07T06:59:30.9008014Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2022-12-07T06:59:30.9009402Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2022-12-07T06:59:30.9023010Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2022-12-07T06:59:30.9031422Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2022-12-07T06:59:30.9046039Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-12-07T06:59:30.9071342Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2022-12-07T06:59:30.9075991Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-12-07T06:59:30.9089501Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2022-12-07T06:59:30.9104370Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2022-12-07T06:59:30.9119362Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2022-12-07T06:59:30.9134497Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2022-12-07T06:59:30.9149973Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2022-12-07T06:59:30.9168949Z ##[debug]Importing alias 'New-PowerBIGroup'. 2022-12-07T06:59:30.9193281Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2022-12-07T06:59:30.9208998Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2022-12-07T06:59:30.9213712Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2022-12-07T06:59:30.9272462Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2022-12-07T06:59:30.9328218Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2022-12-07T06:59:30.9361711Z ##[debug]Loading module from path 'D:\a_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-12-07T06:59:30.9408610Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2022-12-07T06:59:30.9426672Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2022-12-07T06:59:30.9451054Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2022-12-07T06:59:30.9487816Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2022-12-07T06:59:30.9489831Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2022-12-07T06:59:30.9504143Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2022-12-07T06:59:30.9509943Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2022-12-07T06:59:30.9524695Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2022-12-07T06:59:30.9539154Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2022-12-07T06:59:30.9553923Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2022-12-07T06:59:30.9569704Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2022-12-07T06:59:30.9584690Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2022-12-07T06:59:30.9600373Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2022-12-07T06:59:30.9615794Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2022-12-07T06:59:30.9631325Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2022-12-07T06:59:30.9646348Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2022-12-07T06:59:30.9661043Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2022-12-07T06:59:30.9675353Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2022-12-07T06:59:30.9691662Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2022-12-07T06:59:30.9717301Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2022-12-07T06:59:30.9754519Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2022-12-07T06:59:30.9771219Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2022-12-07T06:59:30.9896593Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2022-12-07T06:59:31.0317214Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2022-12-07T06:59:31.0325416Z ##[debug]Loading module from path 'D:\a_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-12-07T06:59:31.0335050Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2022-12-07T06:59:31.0362368Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2022-12-07T06:59:31.0372110Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2022-12-07T06:59:31.0383703Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2022-12-07T06:59:31.0396158Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2022-12-07T06:59:31.0429016Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2022-12-07T06:59:31.0444792Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2022-12-07T06:59:31.0449472Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2022-12-07T06:59:31.0466311Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2022-12-07T06:59:31.0487890Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2022-12-07T06:59:31.0510180Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2022-12-07T06:59:31.0526744Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2022-12-07T06:59:31.0536871Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2022-12-07T06:59:31.0568861Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2022-12-07T06:59:31.0584968Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2022-12-07T06:59:31.0587943Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2022-12-07T06:59:31.0605681Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2022-12-07T06:59:31.0616750Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2022-12-07T06:59:31.0648138Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2022-12-07T06:59:31.0663800Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2022-12-07T06:59:31.0670895Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2022-12-07T06:59:31.0704774Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2022-12-07T06:59:31.0711171Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2022-12-07T06:59:31.0746701Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2022-12-07T06:59:31.0753401Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2022-12-07T06:59:31.0785106Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2022-12-07T06:59:31.0792771Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2022-12-07T06:59:31.0801668Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2022-12-07T06:59:31.0820791Z ### Trying to import the incorporated module for PowerBI 2022-12-07T06:59:31.0831479Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'. 2022-12-07T06:59:31.1659265Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-12-07T06:59:31.1700094Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-12-07T06:59:31.1711465Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2022-12-07T06:59:31.1728530Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-12-07T06:59:31.1752240Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2022-12-07T06:59:31.1761623Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2022-12-07T06:59:31.1777960Z ##[debug]Exporting function 'Set-DatasetOwnership'. 2022-12-07T06:59:31.1810532Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'. 2022-12-07T06:59:31.1825291Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2022-12-07T06:59:31.1830697Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2022-12-07T06:59:31.1844130Z ##[debug]Exporting function 'Invoke-API'. 2022-12-07T06:59:31.1863868Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2022-12-07T06:59:31.1874519Z ##[debug]Exporting function 'New-DatasetRefresh'. 2022-12-07T06:59:31.1887829Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2022-12-07T06:59:31.1920272Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2022-12-07T06:59:31.1939392Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2022-12-07T06:59:31.1955906Z ##[debug]Exporting function 'Get-PowerBIReport'. 2022-12-07T06:59:31.1961385Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2022-12-07T06:59:31.1973692Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2022-12-07T06:59:31.2003697Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2022-12-07T06:59:31.2024300Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2022-12-07T06:59:31.2039817Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2022-12-07T06:59:31.2046067Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2022-12-07T06:59:31.2058004Z ##[debug]Exporting function 'Import-PowerBIFile'. 2022-12-07T06:59:31.2084445Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2022-12-07T06:59:31.2101451Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2022-12-07T06:59:31.2118595Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2022-12-07T06:59:31.2139792Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2022-12-07T06:59:31.2151553Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2022-12-07T06:59:31.2181410Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2022-12-07T06:59:31.2184775Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2022-12-07T06:59:31.2211480Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2022-12-07T06:59:31.2227177Z ##[debug]Exporting function 'Set-Capacity'. 2022-12-07T06:59:31.2242918Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2022-12-07T06:59:31.2249283Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2022-12-07T06:59:31.2261531Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2022-12-07T06:59:31.2277010Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2022-12-07T06:59:31.2289527Z ##[debug]Exporting function 'Publish-TabularEditor'. 2022-12-07T06:59:31.2303943Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2022-12-07T06:59:31.2323064Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2022-12-07T06:59:31.2365840Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2022-12-07T06:59:31.2372401Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2022-12-07T06:59:31.2392862Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2022-12-07T06:59:31.2407369Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2022-12-07T06:59:31.2435077Z ##[debug]Importing function 'Get-PowerBICapacity'. 2022-12-07T06:59:31.2450336Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2022-12-07T06:59:31.2460624Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2022-12-07T06:59:31.2486287Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-12-07T06:59:31.2493699Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2022-12-07T06:59:31.2528157Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2022-12-07T06:59:31.2532866Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2022-12-07T06:59:31.2573010Z ##[debug]Importing function 'Get-PowerBIGateways'. 2022-12-07T06:59:31.2585825Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2022-12-07T06:59:31.2594527Z ##[debug]Importing function 'Get-PowerBiParameters'. 2022-12-07T06:59:31.2608706Z ##[debug]Importing function 'Get-PowerBIReport'. 2022-12-07T06:59:31.2635212Z ##[debug]Importing function 'Import-PowerBIFile'. 2022-12-07T06:59:31.2650218Z ##[debug]Importing function 'Invoke-API'. 2022-12-07T06:59:31.2657288Z ##[debug]Importing function 'New-DatasetRefresh'. 2022-12-07T06:59:31.2687835Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2022-12-07T06:59:31.2695514Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2022-12-07T06:59:31.2738030Z ##[debug]Importing function 'Publish-PowerBIFile'. 2022-12-07T06:59:31.2745179Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2022-12-07T06:59:31.2780134Z ##[debug]Importing function 'Publish-TabularEditor'. 2022-12-07T06:59:31.2787701Z ##[debug]Importing function 'Redo-PowerBIReport'. 2022-12-07T06:59:31.2798593Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2022-12-07T06:59:31.2828595Z ##[debug]Importing function 'Remove-PowerBIReport'. 2022-12-07T06:59:31.2844601Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2022-12-07T06:59:31.2853840Z ##[debug]Importing function 'Set-Capacity'. 2022-12-07T06:59:31.2863323Z ##[debug]Importing function 'Set-DatasetOwnership'. 2022-12-07T06:59:31.2877956Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'. 2022-12-07T06:59:31.2894109Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-12-07T06:59:31.2907839Z ##[debug]Importing function 'Set-RefreshSchedule'. 2022-12-07T06:59:31.2922235Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2022-12-07T06:59:31.2952948Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2022-12-07T06:59:31.2968805Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2022-12-07T06:59:31.2995895Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2022-12-07T06:59:31.2999881Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-12-07T06:59:31.3015186Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2022-12-07T06:59:31.3043200Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2022-12-07T06:59:31.3064444Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2022-12-07T06:59:31.3379554Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '332e12ea-b397-42ca-8c21-bdc72afcd972' 2022-12-07T06:59:31.3528066Z ##[debug]ENDPOINT_URL_332e12ea-b397-42ca-8c21-bdc72afcd972: 'https://api.powerbi.com/v1.0/myorg' 2022-12-07T06:59:31.3589949Z ##[debug]ENDPOINT_AUTH_332e12ea-b397-42ca-8c21-bdc72afcd972: '****' 2022-12-07T06:59:31.3600394Z ##[debug]ENDPOINT_DATA_332e12ea-b397-42ca-8c21-bdc72afcd972: '{"OrganizationType":"Public"}' 2022-12-07T06:59:31.4134145Z ##[debug]{ 2022-12-07T06:59:31.4149671Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2022-12-07T06:59:31.4155433Z ##[debug] "Data": { 2022-12-07T06:59:31.4178330Z ##[debug] "OrganizationType": "Public" 2022-12-07T06:59:31.4186359Z ##[debug] }, 2022-12-07T06:59:31.4193117Z ##[debug] "Auth": { 2022-12-07T06:59:31.4203045Z ##[debug] "parameters": { 2022-12-07T06:59:31.4224410Z ##[debug] "TenantId": "415fb......................", 2022-12-07T06:59:31.4236247Z ##[debug] "ClientId": "", 2022-12-07T06:59:31.4246668Z ##[debug] "ClientSecret": , 2022-12-07T06:59:31.4262220Z ##[debug] "ClientCertificate": "" 2022-12-07T06:59:31.4275121Z ##[debug] }, 2022-12-07T06:59:31.4288563Z ##[debug] "scheme": "None" 2022-12-07T06:59:31.4304168Z ##[debug] } 2022-12-07T06:59:31.4364359Z ##[debug]} 2022-12-07T06:59:32.1519132Z ##[debug]6:59:32 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2022-12-07T06:59:32.1610343Z ##[debug]6:59:32 AM - Cmdlet version: 1.2.1077.0 2022-12-07T06:59:32.1994177Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/415fbabb-2f5f-4386-8198-547a7bf14951 2022-12-07T06:59:32.2891037Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32] Found 0 cache accounts and 0 broker accounts 2022-12-07T06:59:32.3002060Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(fcc04368-c311-41fc-acbf-ca4ccd3addc6) 2022-12-07T06:59:32.3010113Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] === AcquireTokenForClientParameters === 2022-12-07T06:59:32.3128287Z ##[debug]SendX5C: False 2022-12-07T06:59:32.3149263Z ##[debug]WithAzureRegion: False 2022-12-07T06:59:32.3150934Z ##[debug]RegionToUse: 2022-12-07T06:59:32.3153611Z ##[debug]ForceRefresh: False 2022-12-07T06:59:32.3154282Z ##[debug] 2022-12-07T06:59:32.3155444Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] 2022-12-07T06:59:32.3191218Z ##[debug]=== Request Data === 2022-12-07T06:59:32.3195132Z ##[debug]Authority Provided? - True 2022-12-07T06:59:32.3200577Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-12-07T06:59:32.3211706Z ##[debug]Extra Query Params Keys (space separated) - 2022-12-07T06:59:32.3226051Z ##[debug]ApiId - AcquireTokenForClient 2022-12-07T06:59:32.3242508Z ##[debug]IsConfidentialClient - True 2022-12-07T06:59:32.3248192Z ##[debug]SendX5C - False 2022-12-07T06:59:32.3278636Z ##[debug]LoginHint ? False 2022-12-07T06:59:32.3293062Z ##[debug]IsBrokerConfigured - False 2022-12-07T06:59:32.3305987Z ##[debug]HomeAccountId - False 2022-12-07T06:59:32.3320047Z ##[debug]CorrelationId - fcc04368-c311-41fc-acbf-ca4ccd3addc6 2022-12-07T06:59:32.3332113Z ##[debug] 2022-12-07T06:59:32.3363566Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] === Token Acquisition (ClientCredentialRequest) started: 2022-12-07T06:59:32.3386301Z ##[debug]
2022-12-07T06:59:32.3508451Z ##[debug] Authority Host: login.microsoftonline.com 2022-12-07T06:59:32.3774938Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Fetching instance discovery from the network from host login.microsoftonline.com. 2022-12-07T06:59:33.3193180Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:32 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Resolving authority endpoints... Already resolved? - FALSE 2022-12-07T06:59:33.3208784Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2022-12-07T06:59:33.3223763Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Checking client info returned from the server.. 2022-12-07T06:59:33.3238669Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Saving Token Response to cache.. 2022-12-07T06:59:33.3253304Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] ID Token not present in response. 2022-12-07T06:59:33.3297393Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Saving AT in cache and removing overlapping ATs... 2022-12-07T06:59:33.3299406Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2022-12-07T06:59:33.3307700Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] Intersecting scope entries count - 0 2022-12-07T06:59:33.3318057Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - fcc04368-c311-41fc-acbf-ca4ccd3addc6] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 12/07/2022 07:59:32 +00:00 === 2022-12-07T06:59:33.3334721Z ##[debug]6:59:33 AM - Connect-PowerBIServiceAccount end processing. 2022-12-07T06:59:33.3355324Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s\Sample PBI File.pbix' 2022-12-07T06:59:33.3374996Z ##[debug]INPUT_WORKSPACENAME: 'TC Merge Demo' 2022-12-07T06:59:33.3394520Z ##[debug]INPUT_OVERWRITE: 'false' 2022-12-07T06:59:33.3427854Z ##[debug] Converted to bool: False 2022-12-07T06:59:33.3447321Z ##[debug]INPUT_CREATE: 'false' 2022-12-07T06:59:33.3461590Z ##[debug] Converted to bool: False 2022-12-07T06:59:33.3480405Z ##[debug]INPUT_ACTION: 'Publish' 2022-12-07T06:59:33.3499953Z ##[debug]INPUT_DATASETNAME (empty) 2022-12-07T06:59:33.3538797Z ##[debug]INPUT_OLDURL (empty) 2022-12-07T06:59:33.3557928Z ##[debug]INPUT_NEWURL (empty) 2022-12-07T06:59:33.3576640Z ##[debug]INPUT_OLDSERVER (empty) 2022-12-07T06:59:33.3595669Z ##[debug]INPUT_NEWSERVER (empty) 2022-12-07T06:59:33.3614396Z ##[debug]INPUT_OLDDATABASE (empty) 2022-12-07T06:59:33.3632799Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2022-12-07T06:59:33.3651427Z ##[debug]INPUT_NEWDATABASE (empty) 2022-12-07T06:59:33.3670413Z ##[debug]INPUT_PERMISSION (empty) 2022-12-07T06:59:33.3689165Z ##[debug]INPUT_USERS (empty) 2022-12-07T06:59:33.3709169Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2022-12-07T06:59:33.3728362Z ##[debug]INPUT_UPDATEALL: 'false' 2022-12-07T06:59:33.3742613Z ##[debug] Converted to bool: False 2022-12-07T06:59:33.3761683Z ##[debug]INPUT_SKIPREPORT: 'false' 2022-12-07T06:59:33.3776039Z ##[debug] Converted to bool: False 2022-12-07T06:59:33.3794206Z ##[debug]INPUT_INDIVIDUAL (empty) 2022-12-07T06:59:33.3812597Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2022-12-07T06:59:33.3830758Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2022-12-07T06:59:33.3849334Z ##[debug]INPUT_PARAMETERINPUT (empty) 2022-12-07T06:59:33.3867826Z ##[debug]INPUT_GATEWAYNAME (empty) 2022-12-07T06:59:33.4424565Z ##[debug]INPUT_REPORTNAME (empty) 2022-12-07T06:59:33.4443962Z ##[debug]INPUT_CAPACITYNAME (empty) 2022-12-07T06:59:33.4464355Z ##[debug]INPUT_USERNAME (empty) 2022-12-07T06:59:33.4484045Z ##[debug]INPUT_PASSWORD (empty) 2022-12-07T06:59:33.5132111Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2022-12-07T06:59:33.5134429Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2022-12-07T06:59:33.5161208Z ##[debug] Converted to bool: False 2022-12-07T06:59:33.5182876Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2022-12-07T06:59:33.5233800Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2022-12-07T06:59:33.5253969Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2022-12-07T06:59:33.5276482Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2022-12-07T06:59:33.5295811Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2022-12-07T06:59:33.5323296Z ##[debug]INPUT_DATASETACCESSRIGHT (empty) 2022-12-07T06:59:33.5338806Z ##[debug]WorkspaceName : TC Merge Demo 2022-12-07T06:59:33.5354408Z ##[debug]Create : False 2022-12-07T06:59:33.5369655Z ##[debug]File patern : D:\a\1\s\Sample PBI File.pbix 2022-12-07T06:59:33.5399040Z ##[debug]Remove report : False 2022-12-07T06:59:33.5516729Z Getting Power BI Workspace properties; TC Merge Demo 2022-12-07T06:59:33.5568401Z ##[debug]6:59:33 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2022-12-07T06:59:33.5583195Z ##[debug]6:59:33 AM - Cmdlet version: 1.2.1077.0 2022-12-07T06:59:33.5824151Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33] Found 0 cache accounts and 0 broker accounts 2022-12-07T06:59:33.5839959Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(cb2b4264-0a95-4444-b8ec-6aa21b5fac57) 2022-12-07T06:59:33.5856905Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] === AcquireTokenForClientParameters === 2022-12-07T06:59:33.5867404Z ##[debug]SendX5C: False 2022-12-07T06:59:33.5879580Z ##[debug]WithAzureRegion: False 2022-12-07T06:59:33.5890417Z ##[debug]RegionToUse: 2022-12-07T06:59:33.5902163Z ##[debug]ForceRefresh: False 2022-12-07T06:59:33.5912669Z ##[debug] 2022-12-07T06:59:33.5929883Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] 2022-12-07T06:59:33.5940282Z ##[debug]=== Request Data === 2022-12-07T06:59:33.5950902Z ##[debug]Authority Provided? - True 2022-12-07T06:59:33.5961547Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-12-07T06:59:33.5971977Z ##[debug]Extra Query Params Keys (space separated) - 2022-12-07T06:59:33.5982426Z ##[debug]ApiId - AcquireTokenForClient 2022-12-07T06:59:33.5992845Z ##[debug]IsConfidentialClient - True 2022-12-07T06:59:33.6003266Z ##[debug]SendX5C - False 2022-12-07T06:59:33.6013725Z ##[debug]LoginHint ? False 2022-12-07T06:59:33.6024185Z ##[debug]IsBrokerConfigured - False 2022-12-07T06:59:33.6034896Z ##[debug]HomeAccountId - False 2022-12-07T06:59:33.6045442Z ##[debug]CorrelationId - cb2b4264-0a95-4444-b8ec-6aa21b5fac57 2022-12-07T06:59:33.6055658Z ##[debug] 2022-12-07T06:59:33.6070694Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] === Token Acquisition (ClientCredentialRequest) started: 2022-12-07T06:59:33.6080756Z ##[debug]
2022-12-07T06:59:33.6091337Z ##[debug] Authority Host: login.microsoftonline.com 2022-12-07T06:59:33.6140082Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] Access token is not expired. Returning the found cache entry. [Current time (12/07/2022 06:59:33) - Expiration Time (12/07/2022 07:59:32 +00:00) - Extended Expiration Time (12/07/2022 07:59:32 +00:00)] 2022-12-07T06:59:33.6162627Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [12/07/2022 06:59:33 - cb2b4264-0a95-4444-b8ec-6aa21b5fac57] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 12/07/2022 07:59:32 +00:00 === 2022-12-07T06:59:34.3971370Z ##[debug]Error record: 2022-12-07T06:59:34.4505269Z ##[debug]Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized' 2022-12-07T06:59:34.4516357Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1:676 char:22 2022-12-07T06:59:34.4527297Z ##[debug]+ ... $workspace = Get-PowerBIWorkspace -Name $WorkspaceName -Verbose 2022-12-07T06:59:34.4538200Z ##[debug]+ ~~~~~~~~~~ 2022-12-07T06:59:34.4549364Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...owerBIWorkspace:GetPowerBIWorkspace) [Get-PowerBIWorkspac e], HttpOperationException 2022-12-07T06:59:34.4560248Z ##[debug] + FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Work spaces.GetPowerBIWorkspace 2022-12-07T06:59:34.4570770Z ##[debug] 2022-12-07T06:59:34.4588092Z ##[debug]Script stack trace: 2022-12-07T06:59:34.4618732Z ##[debug]at Get-PowerBIGroupPath, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 676 2022-12-07T06:59:34.4629614Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 766 2022-12-07T06:59:34.4640671Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1: line 116 2022-12-07T06:59:34.4651263Z ##[debug]at , : line 1 2022-12-07T06:59:34.4662010Z ##[debug]at , : line 22 2022-12-07T06:59:34.4672578Z ##[debug]at , : line 18 2022-12-07T06:59:34.4683235Z ##[debug]at , : line 1 2022-12-07T06:59:34.4699933Z ##[debug]Exception: 2022-12-07T06:59:34.4881560Z ##[debug]Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'Unauthorized' 2022-12-07T06:59:34.4892622Z ##[debug] at Microsoft.PowerBI.Api.V2.Groups.d5.MoveNext() 2022-12-07T06:59:34.4903377Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2022-12-07T06:59:34.4914111Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2022-12-07T06:59:34.4924775Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2022-12-07T06:59:34.4935364Z ##[debug] at Microsoft.PowerBI.Api.V2.GroupsExtensions.d1.MoveNext() 2022-12-07T06:59:34.4946045Z ##[debug]--- End of stack trace from previous location where exception was thrown --- 2022-12-07T06:59:34.4957852Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 2022-12-07T06:59:34.4968423Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2022-12-07T06:59:34.4979244Z ##[debug] at Microsoft.PowerBI.Api.V2.GroupsExtensions.GetGroups(IGroups operations, String filter, Nullable1 top, Nullable1 skip) 2022-12-07T06:59:34.4989952Z ##[debug] at Microsoft.PowerBI.Common.Api.Workspaces.WorkspacesClient.GetWorkspaces(String filter, Nullable1 top, Nullable1 skip) 2022-12-07T06:59:34.5000599Z ##[debug] at Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace.GetWorkspaces() 2022-12-07T06:59:34.5011310Z ##[debug] at Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace.ExecuteCmdlet() 2022-12-07T06:59:34.5022117Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord() 2022-12-07T06:59:34.5247020Z ##[error]Operation returned an invalid status code 'Unauthorized' 2022-12-07T06:59:34.5256718Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'Unauthorized' 2022-12-07T06:59:34.5257831Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'tc merge demo'&$top=100 2022-12-07T06:59:34.5258580Z ##[debug]Status Code: Unauthorized (401) 2022-12-07T06:59:34.5264783Z ##[debug]6:59:34 AM - Get-PowerBIWorkspace end processing. 2022-12-07T06:59:34.6079343Z Done processing Power BI Actions 2022-12-07T06:59:34.6440612Z ##[debug]Caught exception from task script. 2022-12-07T06:59:34.6462290Z ##[debug]Error record: 2022-12-07T06:59:34.6595411Z ##[debug]Power BI Workspace: TC Merge Demo does not exist 2022-12-07T06:59:34.6606864Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1:682 char:13 2022-12-07T06:59:34.6617800Z ##[debug]+ Throw "Power BI Workspace: $WorkspaceName does not exist" 2022-12-07T06:59:34.6628716Z ##[debug]+ ~~~~~~~~~~~~~ 2022-12-07T06:59:34.6751084Z ##[debug] + CategoryInfo : OperationStopped: (Power BI Worksp... does not exist:String) [], RuntimeException 2022-12-07T06:59:34.6762069Z ##[debug] + FullyQualifiedErrorId : Power BI Workspace: TC Merge Demo does not exist 2022-12-07T06:59:34.6773055Z ##[debug] 2022-12-07T06:59:34.6790768Z ##[debug]Script stack trace: 2022-12-07T06:59:34.6808060Z ##[debug]at Get-PowerBIGroupPath, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 682 2022-12-07T06:59:34.6819116Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 766 2022-12-07T06:59:34.6829763Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1: line 116 2022-12-07T06:59:34.6840297Z ##[debug]at , : line 1 2022-12-07T06:59:34.6850981Z ##[debug]at , : line 22 2022-12-07T06:59:34.6861613Z ##[debug]at , : line 18 2022-12-07T06:59:34.6872501Z ##[debug]at , : line 1 2022-12-07T06:59:34.6888509Z ##[debug]Exception: 2022-12-07T06:59:34.6926297Z ##[debug]System.Management.Automation.RuntimeException: Power BI Workspace: TC Merge Demo does not exist 2022-12-07T06:59:34.6941641Z ##[error]Power BI Workspace: TC Merge Demo does not exist 2022-12-07T06:59:34.6942508Z ##[debug]Processed: ##vso[task.logissue type=error]Power BI Workspace: TC Merge Demo does not exist 2022-12-07T06:59:34.6959235Z ##[debug]Processed: ##vso[task.complete result=Failed] 2022-12-07T06:59:34.7247459Z ##[section]Finishing: Power BI Action: Publish

Thankyou...

maikvandergaag commented 1 year ago

Please check your permissions for the authentication used. The error shown in the logs. shows it cannot find the specified workspace:

2022-12-07T06:59:34.6926297Z ##[debug]System.Management.Automation.RuntimeException: Power BI Workspace: TC Merge Demo does not exist

Pass1406 commented 1 year ago

Thanks for the reply, the permissions are been given, can you guide with which more permissions should be required ..if any ss

maikvandergaag commented 1 year ago

That all depends on the actions you would like to perform. But it is also very important that it has the correct permissions in in Power BI.

maikvandergaag commented 1 year ago

Did you find the issue with your setup?

maikvandergaag commented 1 year ago

Closing this issue because of no response