search

maikvandergaag / msft-extensions

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

(400) Bad request error with overwrite: true & skipreport: true when overwriting dataset with no report of the same name in workspace #393

Closed lululorcan closed 2 years ago

lululorcan commented 2 years ago

Hi there,

Publishing a report when workspace empty -> Pass Publishing a report to overwrite existing reports -> Fail

Publishing the report manually to overwrite the existing report works fine.

Logs below

2022-04-08T23:30:49.8723723Z ##[section]Starting: Power BI Action: Publish
2022-04-08T23:30:49.8839752Z ==============================================================================
2022-04-08T23:30:49.8840066Z Task         : Power BI Actions
2022-04-08T23:30:49.8840301Z Description  : Release Task Power BI Actions
2022-04-08T23:30:49.8840521Z Version      : 5.4.31
2022-04-08T23:30:49.8840705Z Author       : Maik van der Gaag
2022-04-08T23:30:49.8840897Z Help         : 
2022-04-08T23:30:49.8841129Z ==============================================================================
2022-04-08T23:30:50.8236692Z Starting Power BI Actions extension
2022-04-08T23:30:50.8394960Z ### Required Module is needed. Importing now...
2022-04-08T23:30:50.9547146Z ### Trying to import the incorporated module for PowerBI
2022-04-08T23:30:52.3365254Z Getting Power BI Workspace properties; PBI - DevOPS - DEV/QA
2022-04-08T23:30:53.0738982Z Trying to publish PowerBI File: D:\a\1\s\Today’s Sales DEV.pbix
2022-04-08T23:30:53.0772954Z Checking for existing Reports with the name: Today’s Sales DEV
2022-04-08T23:30:53.1863367Z Importing PowerBI File
2022-04-08T23:30:54.2959792Z Done processing Power BI Actions
2022-04-08T23:30:54.4480156Z ##[error]The remote server returned an error: (400) Bad Request.
2022-04-08T23:30:54.4765312Z ##[section]Finishing: Power BI Action: Publish

YAML below:

trigger:
- Development

pool:
  vmImage: windows-latest

stages: 
- stage: Build
  jobs:
    - job: Publish
      steps:
      - checkout: self
        lfs: true
      - task: PowerBIActions@5
        displayName: 'Power BI Action: Publish'
        inputs:
          PowerBIServiceEndpoint: 'sr-powerbi-dip'
          SkipReport: true
          Action: 'Publish'
          WorkspaceName: 'PBI - DevOPS - DEV/QA'
          PowerBIPath: "$(System.DefaultWorkingDirectory)/**.pbix"
          Create: false
lululorcan commented 2 years ago

With variables: System.Debug: true

2022-04-09T00:01:41.3724044Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish'
2022-04-09T00:01:41.3726274Z ##[debug]Evaluating: SucceededNode()
2022-04-09T00:01:41.3727276Z ##[debug]Evaluating SucceededNode:
2022-04-09T00:01:41.3728534Z ##[debug]=> True
2022-04-09T00:01:41.3729064Z ##[debug]Result: True
2022-04-09T00:01:41.3729540Z ##[section]Starting: Power BI Action: Publish
2022-04-09T00:01:41.3844507Z ==============================================================================
2022-04-09T00:01:41.3844802Z Task         : Power BI Actions
2022-04-09T00:01:41.3845017Z Description  : Release Task Power BI Actions
2022-04-09T00:01:41.3845231Z Version      : 5.4.31
2022-04-09T00:01:41.3845406Z Author       : Maik van der Gaag
2022-04-09T00:01:41.3845588Z Help         : 
2022-04-09T00:01:41.3845818Z ==============================================================================
2022-04-09T00:01:42.2500989Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2022-04-09T00:01:42.4403979Z Starting Power BI Actions extension
2022-04-09T00:01:42.4523764Z ##[debug]Entering D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1.
2022-04-09T00:01:42.4588796Z ### Required Module is needed. Importing now...
2022-04-09T00:01:42.4629881Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2022-04-09T00:01:42.4702241Z ##[debug]Loading 'TypesToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2022-04-09T00:01:42.4786525Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2022-04-09T00:01:42.4985529Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2022-04-09T00:01:42.5012057Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2022-04-09T00:01:42.5097732Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-09T00:01:42.5144699Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-09T00:01:42.5145918Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2022-04-09T00:01:42.5149673Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-09T00:01:42.5166126Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2022-04-09T00:01:42.5183093Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-09T00:01:42.5199858Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-09T00:01:42.5216426Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2022-04-09T00:01:42.5232935Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-09T00:01:42.5249457Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2022-04-09T00:01:42.5266138Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2022-04-09T00:01:42.5282688Z ##[debug]Importing alias 'Login-PowerBI'.
2022-04-09T00:01:42.5299547Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2022-04-09T00:01:42.5318997Z ##[debug]Importing alias 'Logout-PowerBI'.
2022-04-09T00:01:42.5336054Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2022-04-09T00:01:42.5352647Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2022-04-09T00:01:42.5369142Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2022-04-09T00:01:42.5403422Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2022-04-09T00:01:42.5466983Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2022-04-09T00:01:42.5653788Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2022-04-09T00:01:42.5681440Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2022-04-09T00:01:42.5754345Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-09T00:01:42.5771215Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2022-04-09T00:01:42.6756397Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-09T00:01:42.6771434Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2022-04-09T00:01:42.6800292Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-09T00:01:42.6836436Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2022-04-09T00:01:42.6837596Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2022-04-09T00:01:42.6854202Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-09T00:01:42.6865041Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2022-04-09T00:01:42.6876134Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-09T00:01:42.6891167Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2022-04-09T00:01:42.6906359Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-09T00:01:42.6921195Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2022-04-09T00:01:42.6936076Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2022-04-09T00:01:42.6951006Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2022-04-09T00:01:42.6965981Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2022-04-09T00:01:42.6982042Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2022-04-09T00:01:42.6997353Z ##[debug]Importing alias 'New-PowerBIGroup'.
2022-04-09T00:01:42.7012861Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2022-04-09T00:01:42.7028209Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2022-04-09T00:01:42.7043480Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2022-04-09T00:01:42.7075717Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2022-04-09T00:01:42.7134902Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2022-04-09T00:01:42.7160672Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2022-04-09T00:01:42.7211070Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2022-04-09T00:01:42.7226697Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2022-04-09T00:01:42.7241938Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2022-04-09T00:01:42.7257460Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2022-04-09T00:01:42.7272861Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2022-04-09T00:01:42.7288935Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2022-04-09T00:01:42.7304519Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2022-04-09T00:01:42.7319920Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2022-04-09T00:01:42.7335113Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2022-04-09T00:01:42.7350519Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2022-04-09T00:01:42.7366335Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2022-04-09T00:01:42.7381604Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2022-04-09T00:01:42.7397785Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2022-04-09T00:01:42.7413053Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2022-04-09T00:01:42.7428299Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2022-04-09T00:01:42.7443613Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2022-04-09T00:01:42.7458867Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2022-04-09T00:01:42.7474171Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2022-04-09T00:01:42.7488661Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2022-04-09T00:01:42.7513003Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2022-04-09T00:01:42.7518375Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2022-04-09T00:01:42.7550220Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2022-04-09T00:01:42.7612622Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2022-04-09T00:01:42.7863034Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2022-04-09T00:01:42.7888233Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2022-04-09T00:01:42.7938453Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2022-04-09T00:01:42.7954093Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2022-04-09T00:01:42.7969727Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2022-04-09T00:01:42.7985033Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2022-04-09T00:01:42.8001277Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-09T00:01:42.8016385Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2022-04-09T00:01:42.8031511Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2022-04-09T00:01:42.8046660Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2022-04-09T00:01:42.8061669Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2022-04-09T00:01:42.8076707Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2022-04-09T00:01:42.8091666Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2022-04-09T00:01:42.8106736Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2022-04-09T00:01:42.8121812Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2022-04-09T00:01:42.8136479Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2022-04-09T00:01:42.8151405Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2022-04-09T00:01:42.8165937Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2022-04-09T00:01:42.8180557Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2022-04-09T00:01:42.8195444Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2022-04-09T00:01:42.8211169Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-09T00:01:42.8226450Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2022-04-09T00:01:42.8241814Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2022-04-09T00:01:42.8256822Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2022-04-09T00:01:42.8273023Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2022-04-09T00:01:42.8287883Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2022-04-09T00:01:42.8302911Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2022-04-09T00:01:42.8317877Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2022-04-09T00:01:42.8333009Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2022-04-09T00:01:42.8347534Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2022-04-09T00:01:42.8355610Z ### Trying to import the incorporated module for PowerBI
2022-04-09T00:01:42.8375931Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1'.
2022-04-09T00:01:43.0714632Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-09T00:01:43.0731734Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-09T00:01:43.0747671Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2022-04-09T00:01:43.0763348Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-09T00:01:43.0778661Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2022-04-09T00:01:43.0793964Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2022-04-09T00:01:43.0808809Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2022-04-09T00:01:43.0823830Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2022-04-09T00:01:43.0838292Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2022-04-09T00:01:43.0852623Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2022-04-09T00:01:43.0866969Z ##[debug]Exporting function 'Invoke-API'.
2022-04-09T00:01:43.0881413Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2022-04-09T00:01:43.0895751Z ##[debug]Exporting function 'New-DatasetRefresh'.
2022-04-09T00:01:43.0910204Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2022-04-09T00:01:43.0924499Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2022-04-09T00:01:43.1816867Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2022-04-09T00:01:43.1834090Z ##[debug]Exporting function 'Get-PowerBIReport'.
2022-04-09T00:01:43.1848539Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2022-04-09T00:01:43.1862894Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2022-04-09T00:01:43.1876568Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2022-04-09T00:01:43.1891451Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2022-04-09T00:01:43.1905352Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2022-04-09T00:01:43.1919688Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2022-04-09T00:01:43.1933446Z ##[debug]Exporting function 'Import-PowerBIFile'.
2022-04-09T00:01:43.1947475Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2022-04-09T00:01:43.1966459Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2022-04-09T00:01:43.1975586Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2022-04-09T00:01:43.1990324Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2022-04-09T00:01:43.2004785Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2022-04-09T00:01:43.2020209Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2022-04-09T00:01:43.2033395Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2022-04-09T00:01:43.2047486Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2022-04-09T00:01:43.2061724Z ##[debug]Exporting function 'Set-Capacity'.
2022-04-09T00:01:43.2075444Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2022-04-09T00:01:43.2090850Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-09T00:01:43.2105000Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2022-04-09T00:01:43.2119233Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2022-04-09T00:01:43.2133104Z ##[debug]Exporting function 'Publish-TabularEditor'.
2022-04-09T00:01:43.2150045Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2022-04-09T00:01:43.2164148Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2022-04-09T00:01:43.2199332Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2022-04-09T00:01:43.2203590Z ##[debug]Importing function 'Get-PowerBICapacity'.
2022-04-09T00:01:43.2204299Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2022-04-09T00:01:43.2217104Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2022-04-09T00:01:43.2231356Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-09T00:01:43.2245686Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2022-04-09T00:01:43.2259779Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2022-04-09T00:01:43.2273801Z ##[debug]Importing function 'Get-PowerBIGateways'.
2022-04-09T00:01:43.2287673Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2022-04-09T00:01:43.2302070Z ##[debug]Importing function 'Get-PowerBiParameters'.
2022-04-09T00:01:43.2316173Z ##[debug]Importing function 'Get-PowerBIReport'.
2022-04-09T00:01:43.2329818Z ##[debug]Importing function 'Import-PowerBIFile'.
2022-04-09T00:01:43.2343842Z ##[debug]Importing function 'Invoke-API'.
2022-04-09T00:01:43.2357758Z ##[debug]Importing function 'New-DatasetRefresh'.
2022-04-09T00:01:43.2371690Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2022-04-09T00:01:43.2385637Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2022-04-09T00:01:43.2399503Z ##[debug]Importing function 'Publish-PowerBIFile'.
2022-04-09T00:01:43.2413356Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2022-04-09T00:01:43.2427731Z ##[debug]Importing function 'Publish-TabularEditor'.
2022-04-09T00:01:43.2441611Z ##[debug]Importing function 'Redo-PowerBIReport'.
2022-04-09T00:01:43.2455482Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-09T00:01:43.2469526Z ##[debug]Importing function 'Remove-PowerBIReport'.
2022-04-09T00:01:43.2483498Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2022-04-09T00:01:43.2497379Z ##[debug]Importing function 'Set-Capacity'.
2022-04-09T00:01:43.2511191Z ##[debug]Importing function 'Set-DatasetOwnership'.
2022-04-09T00:01:43.2524957Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2022-04-09T00:01:43.2538809Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-09T00:01:43.2552390Z ##[debug]Importing function 'Set-RefreshSchedule'.
2022-04-09T00:01:43.2566412Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2022-04-09T00:01:43.2580521Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2022-04-09T00:01:43.2594368Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2022-04-09T00:01:43.2608884Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2022-04-09T00:01:43.2622830Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-09T00:01:43.2636691Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2022-04-09T00:01:43.2650610Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2022-04-09T00:01:43.2664471Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2022-04-09T00:01:43.2874921Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '46b0eb2e-0fb1-499b-93f2-30d15caf9d66'
2022-04-09T00:01:43.2989772Z ##[debug]ENDPOINT_URL_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: 'https://api.powerbi.com/v1.0/myorg'
2022-04-09T00:01:43.3010098Z ##[debug]ENDPOINT_AUTH_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '********'
2022-04-09T00:01:43.3032430Z ##[debug]ENDPOINT_DATA_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '{"OrganizationType":"Public"}'
2022-04-09T00:01:43.4242359Z ##[debug]{
2022-04-09T00:01:43.4255613Z ##[debug]    "Url":  "https://api.powerbi.com/v1.0/myorg",
2022-04-09T00:01:43.4268152Z ##[debug]    "Data":  {
2022-04-09T00:01:43.4278986Z ##[debug]                 "OrganizationType":  "Public"
2022-04-09T00:01:43.4289326Z ##[debug]             },
2022-04-09T00:01:43.4300086Z ##[debug]    "Auth":  {
2022-04-09T00:01:43.4311337Z ##[debug]                 "parameters":  {
2022-04-09T00:01:43.4322041Z ##[debug]                                    "TenantId":  "59762c14-55e8-4b58-806e-f6cc47d75b19",
2022-04-09T00:01:43.4333119Z ##[debug]                                    "ClientId":  "***",
2022-04-09T00:01:43.4344107Z ##[debug]                                    "ClientSecret":  ***,
2022-04-09T00:01:43.4353298Z ##[debug]                                    "ClientCertificate":  ""
2022-04-09T00:01:43.4364452Z ##[debug]                                },
2022-04-09T00:01:43.4375121Z ##[debug]                 "scheme":  "None"
2022-04-09T00:01:43.4385813Z ##[debug]             }
2022-04-09T00:01:43.4396311Z ##[debug]}
2022-04-09T00:01:43.6335674Z ##[debug]12:01:43 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2022-04-09T00:01:43.6357842Z ##[debug]12:01:43 AM - Cmdlet version: 1.2.1077.0
2022-04-09T00:01:43.6623629Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/59762c14-55e8-4b58-806e-f6cc47d75b19
2022-04-09T00:01:43.8371718Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43] Found 0 cache accounts and 0 broker accounts
2022-04-09T00:01:43.8434871Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43 - a227bef8-2515-4d58-b93c-2925c91420d8] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(a227bef8-2515-4d58-b93c-2925c91420d8)
2022-04-09T00:01:43.8462457Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43 - a227bef8-2515-4d58-b93c-2925c91420d8] === AcquireTokenForClientParameters ===
2022-04-09T00:01:43.8472794Z ##[debug]SendX5C: False
2022-04-09T00:01:43.8482997Z ##[debug]WithAzureRegion: False
2022-04-09T00:01:43.8493775Z ##[debug]RegionToUse: 
2022-04-09T00:01:43.8504946Z ##[debug]ForceRefresh: False
2022-04-09T00:01:43.8515519Z ##[debug]
2022-04-09T00:01:43.8630809Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43 - a227bef8-2515-4d58-b93c-2925c91420d8] 
2022-04-09T00:01:43.8641607Z ##[debug]=== Request Data ===
2022-04-09T00:01:43.8652212Z ##[debug]Authority Provided? - True
2022-04-09T00:01:43.8663295Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-09T00:01:43.8674030Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-09T00:01:43.8684525Z ##[debug]ApiId - AcquireTokenForClient
2022-04-09T00:01:43.8694908Z ##[debug]IsConfidentialClient - True
2022-04-09T00:01:43.8705535Z ##[debug]SendX5C - False
2022-04-09T00:01:43.8716075Z ##[debug]LoginHint ? False
2022-04-09T00:01:43.8726658Z ##[debug]IsBrokerConfigured - False
2022-04-09T00:01:43.8737249Z ##[debug]HomeAccountId - False
2022-04-09T00:01:43.8747819Z ##[debug]CorrelationId - a227bef8-2515-4d58-b93c-2925c91420d8
2022-04-09T00:01:43.8757760Z ##[debug]
2022-04-09T00:01:43.8783588Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43 - a227bef8-2515-4d58-b93c-2925c91420d8] === Token Acquisition (ClientCredentialRequest) started:
2022-04-09T00:01:43.8794495Z ##[debug]  
2022-04-09T00:01:43.8805369Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-09T00:01:43.9115766Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:43 - a227bef8-2515-4d58-b93c-2925c91420d8] Fetching instance discovery from the network from host login.microsoftonline.com. 
2022-04-09T00:01:44.7144965Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Resolving authority endpoints... Already resolved? - FALSE
2022-04-09T00:01:44.7161154Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] ScopeSet was missing from the token response, so using developer provided scopes in the result. 
2022-04-09T00:01:44.7176091Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Checking client info returned from the server..
2022-04-09T00:01:44.7190503Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Saving Token Response to cache..
2022-04-09T00:01:44.7204874Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] ID Token not present in response. 
2022-04-09T00:01:44.7242742Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Saving AT in cache and removing overlapping ATs...
2022-04-09T00:01:44.7244521Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2022-04-09T00:01:44.7258127Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] Intersecting scope entries count - 0
2022-04-09T00:01:44.7262958Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - a227bef8-2515-4d58-b93c-2925c91420d8] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/09/2022 01:01:43 +00:00 ===
2022-04-09T00:01:44.7279566Z ##[debug]12:01:44 AM - Connect-PowerBIServiceAccount end processing.
2022-04-09T00:01:44.7298744Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s\**.pbix'
2022-04-09T00:01:44.7318446Z ##[debug]INPUT_WORKSPACENAME: 'PBI - DevOPS - DEV/QA'
2022-04-09T00:01:44.7337599Z ##[debug]INPUT_OVERWRITE: 'true'
2022-04-09T00:01:44.7369515Z ##[debug] Converted to bool: True
2022-04-09T00:01:44.7388645Z ##[debug]INPUT_CREATE: 'true'
2022-04-09T00:01:44.7403022Z ##[debug] Converted to bool: True
2022-04-09T00:01:44.7422009Z ##[debug]INPUT_ACTION: 'Publish'
2022-04-09T00:01:44.7440539Z ##[debug]INPUT_DATASETNAME (empty)
2022-04-09T00:01:44.7478964Z ##[debug]INPUT_OLDURL (empty)
2022-04-09T00:01:44.7497123Z ##[debug]INPUT_NEWURL (empty)
2022-04-09T00:01:44.7515965Z ##[debug]INPUT_OLDSERVER (empty)
2022-04-09T00:01:44.7535109Z ##[debug]INPUT_NEWSERVER (empty)
2022-04-09T00:01:44.7554132Z ##[debug]INPUT_OLDDATABASE (empty)
2022-04-09T00:01:44.7572726Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2022-04-09T00:01:44.7591066Z ##[debug]INPUT_NEWDATABASE (empty)
2022-04-09T00:01:44.7609303Z ##[debug]INPUT_PERMISSION (empty)
2022-04-09T00:01:44.7627553Z ##[debug]INPUT_USERS (empty)
2022-04-09T00:01:44.7646363Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2022-04-09T00:01:44.7665872Z ##[debug]INPUT_UPDATEALL: 'false'
2022-04-09T00:01:44.7679564Z ##[debug] Converted to bool: False
2022-04-09T00:01:44.7698918Z ##[debug]INPUT_SKIPREPORT: 'true'
2022-04-09T00:01:44.7713314Z ##[debug] Converted to bool: True
2022-04-09T00:01:44.7731907Z ##[debug]INPUT_INDIVIDUAL (empty)
2022-04-09T00:01:44.7750333Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2022-04-09T00:01:44.7769189Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2022-04-09T00:01:44.7787566Z ##[debug]INPUT_PARAMETERINPUT (empty)
2022-04-09T00:01:44.7932639Z ##[debug]INPUT_GATEWAYNAME (empty)
2022-04-09T00:01:44.7951383Z ##[debug]INPUT_REPORTNAME (empty)
2022-04-09T00:01:44.7970215Z ##[debug]INPUT_CAPACITYNAME (empty)
2022-04-09T00:01:44.7988434Z ##[debug]INPUT_USERNAME (empty)
2022-04-09T00:01:44.8006773Z ##[debug]INPUT_PASSWORD (empty)
2022-04-09T00:01:44.8653980Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2022-04-09T00:01:44.8682561Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2022-04-09T00:01:44.8703260Z ##[debug] Converted to bool: False
2022-04-09T00:01:44.8722374Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2022-04-09T00:01:44.8730556Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2022-04-09T00:01:44.8752002Z ##[debug]WorkspaceName         : PBI - DevOPS - DEV/QA
2022-04-09T00:01:44.8766522Z ##[debug]Create                : True
2022-04-09T00:01:44.8781190Z ##[debug]File patern             : D:\a\1\s\**.pbix
2022-04-09T00:01:44.8795612Z ##[debug]Remove report           : True
2022-04-09T00:01:44.9036197Z Getting Power BI Workspace properties; PBI - DevOPS - DEV/QA
2022-04-09T00:01:44.9087656Z ##[debug]12:01:44 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-09T00:01:44.9102262Z ##[debug]12:01:44 AM - Cmdlet version: 1.2.1077.0
2022-04-09T00:01:44.9732232Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44] Found 0 cache accounts and 0 broker accounts
2022-04-09T00:01:44.9749328Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - 93f81ce7-fb11-4ca1-8361-f25604039d66] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(93f81ce7-fb11-4ca1-8361-f25604039d66)
2022-04-09T00:01:44.9764413Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - 93f81ce7-fb11-4ca1-8361-f25604039d66] === AcquireTokenForClientParameters ===
2022-04-09T00:01:44.9774539Z ##[debug]SendX5C: False
2022-04-09T00:01:44.9784845Z ##[debug]WithAzureRegion: False
2022-04-09T00:01:44.9795176Z ##[debug]RegionToUse: 
2022-04-09T00:01:44.9805455Z ##[debug]ForceRefresh: False
2022-04-09T00:01:44.9815630Z ##[debug]
2022-04-09T00:01:44.9831545Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - 93f81ce7-fb11-4ca1-8361-f25604039d66] 
2022-04-09T00:01:44.9841984Z ##[debug]=== Request Data ===
2022-04-09T00:01:44.9851980Z ##[debug]Authority Provided? - True
2022-04-09T00:01:44.9862273Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-09T00:01:44.9872222Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-09T00:01:44.9882243Z ##[debug]ApiId - AcquireTokenForClient
2022-04-09T00:01:44.9892110Z ##[debug]IsConfidentialClient - True
2022-04-09T00:01:44.9902063Z ##[debug]SendX5C - False
2022-04-09T00:01:44.9912026Z ##[debug]LoginHint ? False
2022-04-09T00:01:44.9921623Z ##[debug]IsBrokerConfigured - False
2022-04-09T00:01:44.9931303Z ##[debug]HomeAccountId - False
2022-04-09T00:01:44.9940933Z ##[debug]CorrelationId - 93f81ce7-fb11-4ca1-8361-f25604039d66
2022-04-09T00:01:44.9950378Z ##[debug]
2022-04-09T00:01:44.9964990Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:44 - 93f81ce7-fb11-4ca1-8361-f25604039d66] === Token Acquisition (ClientCredentialRequest) started:
2022-04-09T00:01:44.9974638Z ##[debug]  
2022-04-09T00:01:44.9984553Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-09T00:01:45.0056622Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 93f81ce7-fb11-4ca1-8361-f25604039d66] Access token is not expired. Returning the found cache entry. [Current time (04/09/2022 00:01:45) - Expiration Time (04/09/2022 01:01:43 +00:00) - Extended Expiration Time (04/09/2022 01:01:43 +00:00)]
2022-04-09T00:01:45.0079038Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 93f81ce7-fb11-4ca1-8361-f25604039d66] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/09/2022 01:01:43 +00:00 ===
2022-04-09T00:01:45.8931106Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi - devops - dev/qa'&$top=100
2022-04-09T00:01:45.8931906Z ##[debug]Status Code: OK (200)
2022-04-09T00:01:45.8932505Z ##[debug]12:01:45 AM - Get-PowerBIWorkspace end processing.
2022-04-09T00:01:45.8939936Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]ba8159af-9cf0-4f44-ba1a-3308e266b550
2022-04-09T00:01:45.8955109Z Trying to publish PowerBI File: D:\a\1\s\Today’s Sales DEV.pbix
2022-04-09T00:01:45.8955638Z Checking for existing Reports with the name: Today’s Sales DEV
2022-04-09T00:01:45.8956451Z ##[debug]12:01:45 AM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-09T00:01:45.8957362Z ##[debug]12:01:45 AM - Cmdlet version: 1.2.1077.0
2022-04-09T00:01:45.8958136Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45] Found 0 cache accounts and 0 broker accounts
2022-04-09T00:01:45.8959225Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(47470271-7e32-42c2-a7e3-6a77ec460382)
2022-04-09T00:01:45.8960392Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] === AcquireTokenForClientParameters ===
2022-04-09T00:01:45.8961156Z ##[debug]SendX5C: False
2022-04-09T00:01:45.8961670Z ##[debug]WithAzureRegion: False
2022-04-09T00:01:45.8962185Z ##[debug]RegionToUse: 
2022-04-09T00:01:45.8962685Z ##[debug]ForceRefresh: False
2022-04-09T00:01:45.8963396Z ##[debug]
2022-04-09T00:01:45.8964079Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] 
2022-04-09T00:01:45.8965580Z ##[debug]=== Request Data ===
2022-04-09T00:01:45.8966115Z ##[debug]Authority Provided? - True
2022-04-09T00:01:45.8966875Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-09T00:01:45.8967497Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-09T00:01:45.8968068Z ##[debug]ApiId - AcquireTokenForClient
2022-04-09T00:01:45.8968611Z ##[debug]IsConfidentialClient - True
2022-04-09T00:01:45.8969139Z ##[debug]SendX5C - False
2022-04-09T00:01:45.8969633Z ##[debug]LoginHint ? False
2022-04-09T00:01:45.8970154Z ##[debug]IsBrokerConfigured - False
2022-04-09T00:01:45.8970679Z ##[debug]HomeAccountId - False
2022-04-09T00:01:45.8971254Z ##[debug]CorrelationId - 47470271-7e32-42c2-a7e3-6a77ec460382
2022-04-09T00:01:45.8971798Z ##[debug]
2022-04-09T00:01:45.8972582Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] === Token Acquisition (ClientCredentialRequest) started:
2022-04-09T00:01:45.8973349Z ##[debug]  
2022-04-09T00:01:45.8973868Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-09T00:01:45.8974985Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] Access token is not expired. Returning the found cache entry. [Current time (04/09/2022 00:01:45) - Expiration Time (04/09/2022 01:01:43 +00:00) - Extended Expiration Time (04/09/2022 01:01:43 +00:00)]
2022-04-09T00:01:45.8976438Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:45 - 47470271-7e32-42c2-a7e3-6a77ec460382] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/09/2022 01:01:43 +00:00 ===
2022-04-09T00:01:45.8977475Z ##[debug]12:01:45 AM - Get-PowerBIAccessToken end processing.
2022-04-09T00:01:45.8978209Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports
2022-04-09T00:01:45.8979030Z ##[debug]GET https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports with 0-byte payload
2022-04-09T00:01:45.8979906Z ##[debug]received -1-byte response of content type application/json; odata.metadata=minimal; odata.streaming=true
2022-04-09T00:01:45.8980597Z ##[debug]Trying to find report 'Today’s Sales DEV'
2022-04-09T00:01:45.8980967Z Importing PowerBI File
2022-04-09T00:01:51.0888068Z ##[debug]12:01:51 AM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-09T00:01:51.0902075Z ##[debug]12:01:51 AM - Cmdlet version: 1.2.1077.0
2022-04-09T00:01:51.0920006Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51] Found 0 cache accounts and 0 broker accounts
2022-04-09T00:01:51.0933660Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(bdefcd1a-990b-4523-855a-a688669b2f6b)
2022-04-09T00:01:51.0948145Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] === AcquireTokenForClientParameters ===
2022-04-09T00:01:51.0957955Z ##[debug]SendX5C: False
2022-04-09T00:01:51.0967905Z ##[debug]WithAzureRegion: False
2022-04-09T00:01:51.0977717Z ##[debug]RegionToUse: 
2022-04-09T00:01:51.0987560Z ##[debug]ForceRefresh: False
2022-04-09T00:01:51.0997438Z ##[debug]
2022-04-09T00:01:51.1012123Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] 
2022-04-09T00:01:51.1023282Z ##[debug]=== Request Data ===
2022-04-09T00:01:51.1033803Z ##[debug]Authority Provided? - True
2022-04-09T00:01:51.1044029Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-09T00:01:51.1054129Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-09T00:01:51.1063882Z ##[debug]ApiId - AcquireTokenForClient
2022-04-09T00:01:51.1073781Z ##[debug]IsConfidentialClient - True
2022-04-09T00:01:51.1083681Z ##[debug]SendX5C - False
2022-04-09T00:01:51.1093360Z ##[debug]LoginHint ? False
2022-04-09T00:01:51.1103021Z ##[debug]IsBrokerConfigured - False
2022-04-09T00:01:51.1113236Z ##[debug]HomeAccountId - False
2022-04-09T00:01:51.1123430Z ##[debug]CorrelationId - bdefcd1a-990b-4523-855a-a688669b2f6b
2022-04-09T00:01:51.1133623Z ##[debug]
2022-04-09T00:01:51.1148867Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] === Token Acquisition (ClientCredentialRequest) started:
2022-04-09T00:01:51.1158337Z ##[debug]  
2022-04-09T00:01:51.1168425Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-09T00:01:51.1183974Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] Access token is not expired. Returning the found cache entry. [Current time (04/09/2022 00:01:51) - Expiration Time (04/09/2022 01:01:43 +00:00) - Extended Expiration Time (04/09/2022 01:01:43 +00:00)]
2022-04-09T00:01:51.1198078Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/09/2022 00:01:51 - bdefcd1a-990b-4523-855a-a688669b2f6b] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/09/2022 01:01:43 +00:00 ===
2022-04-09T00:01:51.1211805Z ##[debug]12:01:51 AM - Get-PowerBIAccessToken end processing.
2022-04-09T00:01:51.1226978Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=Today%e2%80%99s+Sales+DEV.pbix&nameConflict=Abort&skipReport=True
2022-04-09T00:01:51.9886547Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=Today’s+Sales+DEV.pbix&nameConflict=Abort&skipReport=True with -1-byte payload
2022-04-09T00:01:52.9573176Z Done processing Power BI Actions
2022-04-09T00:01:53.0353150Z ##[debug]Caught exception from task script.
2022-04-09T00:01:53.0385718Z ##[debug]Error record:
2022-04-09T00:01:53.0915262Z ##[debug]Invoke-API : The remote server returned an error: (400) Bad Request.
2022-04-09T00:01:53.0926026Z ##[debug]At D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:655 char:15
2022-04-09T00:01:53.0937346Z ##[debug]+ ...   $result = Invoke-API -Url $url -Method "Post" -Body $body -ContentT ...
2022-04-09T00:01:53.0948064Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-04-09T00:01:53.0958629Z ##[debug]    + CategoryInfo          : NotSpecified: (:) [Write-Error], WebException
2022-04-09T00:01:53.0969104Z ##[debug]    + FullyQualifiedErrorId : System.Net.WebException,Invoke-API
2022-04-09T00:01:53.0979481Z ##[debug] 
2022-04-09T00:01:53.0995563Z ##[debug]Script stack trace:
2022-04-09T00:01:53.1026668Z ##[debug]at Invoke-API, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 311
2022-04-09T00:01:53.1037320Z ##[debug]at Import-PowerBIFile, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 655
2022-04-09T00:01:53.1047480Z ##[debug]at Publish-PowerBIFileApi, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 862
2022-04-09T00:01:53.1057158Z ##[debug]at <ScriptBlock><Process>, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1: line 102
2022-04-09T00:01:53.1066630Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-09T00:01:53.1076740Z ##[debug]at <ScriptBlock>, <No file>: line 22
2022-04-09T00:01:53.1086895Z ##[debug]at <ScriptBlock>, <No file>: line 18
2022-04-09T00:01:53.1096730Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-09T00:01:53.1111833Z ##[debug]Exception:
2022-04-09T00:01:53.1146645Z ##[debug]System.Net.WebException: The remote server returned an error: (400) Bad Request.
2022-04-09T00:01:53.1157412Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
2022-04-09T00:01:53.1168725Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
2022-04-09T00:01:53.1388241Z ##[error]The remote server returned an error: (400) Bad Request.
2022-04-09T00:01:53.1400319Z ##[debug]Processed: ##vso[task.logissue type=error]The remote server returned an error: (400) Bad Request.
2022-04-09T00:01:53.1408388Z ##[debug]Processed: ##vso[task.complete result=Failed]
2022-04-09T00:01:53.1696285Z ##[section]Finishing: Power BI Action: Publish
maikvandergaag commented 2 years ago

For some reason it has a conflict abort query in the post.

Could you please check the configuration of your properties

maikvandergaag commented 2 years ago

Looking at your yaml you are missing the overwrite propety

lululorcan commented 2 years ago

Overwrite is true by default?

I had this 400 error show up in my Release pipeline. To investigate further, I copied the YML code from into a Build Pipeline: image As you can see there is no Overwrite: true in this code.

Nevertheless, I added 'Overwrite: true' to the yaml code and still seeing the error. Below log is an error with overwrite property

2022-04-10T21:49:22.1321765Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish'
2022-04-10T21:49:22.1324457Z ##[debug]Evaluating: SucceededNode()
2022-04-10T21:49:22.1325000Z ##[debug]Evaluating SucceededNode:
2022-04-10T21:49:22.1326137Z ##[debug]=> True
2022-04-10T21:49:22.1326641Z ##[debug]Result: True
2022-04-10T21:49:22.1327065Z ##[section]Starting: Power BI Action: Publish
2022-04-10T21:49:22.1455557Z ==============================================================================
2022-04-10T21:49:22.1455884Z Task         : Power BI Actions
2022-04-10T21:49:22.1456104Z Description  : Release Task Power BI Actions
2022-04-10T21:49:22.1456322Z Version      : 5.4.31
2022-04-10T21:49:22.1456503Z Author       : Maik van der Gaag
2022-04-10T21:49:22.1456694Z Help         : 
2022-04-10T21:49:22.1456922Z ==============================================================================
2022-04-10T21:49:23.0553640Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2022-04-10T21:49:23.2259477Z Starting Power BI Actions extension
2022-04-10T21:49:23.2409782Z ##[debug]Entering D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1.
2022-04-10T21:49:23.2486289Z ### Required Module is needed. Importing now...
2022-04-10T21:49:23.2571273Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2022-04-10T21:49:23.2670660Z ##[debug]Loading 'TypesToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2022-04-10T21:49:23.2713849Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2022-04-10T21:49:23.3046822Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2022-04-10T21:49:23.3083993Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2022-04-10T21:49:23.3243609Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-10T21:49:23.3268401Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-10T21:49:23.3291120Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2022-04-10T21:49:23.3341569Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-10T21:49:23.3368250Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2022-04-10T21:49:23.3392275Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-10T21:49:23.3448165Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-10T21:49:23.3476105Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2022-04-10T21:49:23.3531831Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-10T21:49:23.3555274Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2022-04-10T21:49:23.3598803Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2022-04-10T21:49:23.3623044Z ##[debug]Importing alias 'Login-PowerBI'.
2022-04-10T21:49:23.3666232Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2022-04-10T21:49:23.3689743Z ##[debug]Importing alias 'Logout-PowerBI'.
2022-04-10T21:49:23.3711656Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2022-04-10T21:49:23.3734951Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2022-04-10T21:49:23.3756799Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2022-04-10T21:49:23.3802388Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2022-04-10T21:49:23.3898836Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2022-04-10T21:49:23.4101441Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2022-04-10T21:49:23.4141104Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2022-04-10T21:49:23.4231358Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-10T21:49:23.4258751Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2022-04-10T21:49:23.4284899Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-10T21:49:23.4310500Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2022-04-10T21:49:23.5123864Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-10T21:49:23.5149256Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2022-04-10T21:49:23.5157767Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2022-04-10T21:49:23.5188009Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-10T21:49:23.5215650Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2022-04-10T21:49:23.5244601Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-10T21:49:23.5270105Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2022-04-10T21:49:23.5291865Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-10T21:49:23.5313389Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2022-04-10T21:49:23.5334740Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2022-04-10T21:49:23.5359665Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2022-04-10T21:49:23.5384415Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2022-04-10T21:49:23.5408138Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2022-04-10T21:49:23.5433526Z ##[debug]Importing alias 'New-PowerBIGroup'.
2022-04-10T21:49:23.5453325Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2022-04-10T21:49:23.5477788Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2022-04-10T21:49:23.5504654Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2022-04-10T21:49:23.5544738Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2022-04-10T21:49:23.5620489Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2022-04-10T21:49:23.5655621Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2022-04-10T21:49:23.5711158Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2022-04-10T21:49:23.5732046Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2022-04-10T21:49:23.5755772Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2022-04-10T21:49:23.5774681Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2022-04-10T21:49:23.5795723Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2022-04-10T21:49:23.5818161Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2022-04-10T21:49:23.6637347Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2022-04-10T21:49:23.6659172Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2022-04-10T21:49:23.6681258Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2022-04-10T21:49:23.6701447Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2022-04-10T21:49:23.6724271Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2022-04-10T21:49:23.6743123Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2022-04-10T21:49:23.6764240Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2022-04-10T21:49:23.6785786Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2022-04-10T21:49:23.6810268Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2022-04-10T21:49:23.6842597Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2022-04-10T21:49:23.6863517Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2022-04-10T21:49:23.6886512Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2022-04-10T21:49:23.6904684Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2022-04-10T21:49:23.6925714Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2022-04-10T21:49:23.6944319Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2022-04-10T21:49:23.6982032Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2022-04-10T21:49:23.7215133Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2022-04-10T21:49:23.7482483Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2022-04-10T21:49:23.7540104Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2022-04-10T21:49:23.7603924Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2022-04-10T21:49:23.7652889Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2022-04-10T21:49:23.7674146Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2022-04-10T21:49:23.7693007Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2022-04-10T21:49:23.7713697Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-10T21:49:23.7732474Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2022-04-10T21:49:23.7753319Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2022-04-10T21:49:23.7772363Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2022-04-10T21:49:23.7792866Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2022-04-10T21:49:23.7838181Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2022-04-10T21:49:23.7863292Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2022-04-10T21:49:23.7884312Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2022-04-10T21:49:23.7912747Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2022-04-10T21:49:23.7934482Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2022-04-10T21:49:23.7990206Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2022-04-10T21:49:23.8010628Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2022-04-10T21:49:23.8051411Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2022-04-10T21:49:23.8071621Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2022-04-10T21:49:23.8093430Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-10T21:49:23.8143667Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2022-04-10T21:49:23.8167175Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2022-04-10T21:49:23.8188929Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2022-04-10T21:49:23.8216888Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2022-04-10T21:49:23.8266881Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2022-04-10T21:49:23.8288364Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2022-04-10T21:49:23.8317071Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2022-04-10T21:49:23.8344393Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2022-04-10T21:49:23.8371572Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2022-04-10T21:49:23.8386768Z ### Trying to import the incorporated module for PowerBI
2022-04-10T21:49:23.8445362Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1'.
2022-04-10T21:49:23.8787947Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-10T21:49:23.8823433Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-10T21:49:23.8846400Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2022-04-10T21:49:23.8898305Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-10T21:49:23.8920446Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2022-04-10T21:49:23.8944243Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2022-04-10T21:49:23.8965998Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2022-04-10T21:49:23.8987551Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2022-04-10T21:49:23.9007614Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2022-04-10T21:49:23.9055822Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2022-04-10T21:49:23.9076815Z ##[debug]Exporting function 'Invoke-API'.
2022-04-10T21:49:23.9129727Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2022-04-10T21:49:23.9151563Z ##[debug]Exporting function 'New-DatasetRefresh'.
2022-04-10T21:49:23.9187699Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2022-04-10T21:49:23.9235178Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2022-04-10T21:49:23.9258353Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2022-04-10T21:49:23.9278666Z ##[debug]Exporting function 'Get-PowerBIReport'.
2022-04-10T21:49:23.9303363Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2022-04-10T21:49:23.9325403Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2022-04-10T21:49:23.9360111Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2022-04-10T21:49:23.9386634Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2022-04-10T21:49:23.9428725Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2022-04-10T21:49:23.9525611Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2022-04-10T21:49:23.9548191Z ##[debug]Exporting function 'Import-PowerBIFile'.
2022-04-10T21:49:23.9570659Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2022-04-10T21:49:23.9592054Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2022-04-10T21:49:23.9646752Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2022-04-10T21:49:23.9688370Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2022-04-10T21:49:23.9713989Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2022-04-10T21:49:23.9734880Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2022-04-10T21:49:23.9787026Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2022-04-10T21:49:23.9809903Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2022-04-10T21:49:23.9830505Z ##[debug]Exporting function 'Set-Capacity'.
2022-04-10T21:49:23.9885047Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2022-04-10T21:49:23.9903523Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-10T21:49:23.9931004Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2022-04-10T21:49:23.9953950Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2022-04-10T21:49:23.9975376Z ##[debug]Exporting function 'Publish-TabularEditor'.
2022-04-10T21:49:24.0056676Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2022-04-10T21:49:24.0081430Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2022-04-10T21:49:24.0149314Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2022-04-10T21:49:24.0193865Z ##[debug]Importing function 'Get-PowerBICapacity'.
2022-04-10T21:49:24.0231041Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2022-04-10T21:49:24.0279132Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2022-04-10T21:49:24.0307687Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-10T21:49:24.0329738Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2022-04-10T21:49:24.0377304Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2022-04-10T21:49:24.0428440Z ##[debug]Importing function 'Get-PowerBIGateways'.
2022-04-10T21:49:24.0449988Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2022-04-10T21:49:24.0474110Z ##[debug]Importing function 'Get-PowerBiParameters'.
2022-04-10T21:49:24.0497847Z ##[debug]Importing function 'Get-PowerBIReport'.
2022-04-10T21:49:24.0527339Z ##[debug]Importing function 'Import-PowerBIFile'.
2022-04-10T21:49:24.0578749Z ##[debug]Importing function 'Invoke-API'.
2022-04-10T21:49:24.0627112Z ##[debug]Importing function 'New-DatasetRefresh'.
2022-04-10T21:49:24.0650668Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2022-04-10T21:49:24.0698537Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2022-04-10T21:49:24.0722278Z ##[debug]Importing function 'Publish-PowerBIFile'.
2022-04-10T21:49:24.0745729Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2022-04-10T21:49:24.0786947Z ##[debug]Importing function 'Publish-TabularEditor'.
2022-04-10T21:49:24.0810763Z ##[debug]Importing function 'Redo-PowerBIReport'.
2022-04-10T21:49:24.0836956Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-10T21:49:24.0877976Z ##[debug]Importing function 'Remove-PowerBIReport'.
2022-04-10T21:49:24.0906636Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2022-04-10T21:49:24.0926923Z ##[debug]Importing function 'Set-Capacity'.
2022-04-10T21:49:24.0975421Z ##[debug]Importing function 'Set-DatasetOwnership'.
2022-04-10T21:49:24.1003626Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2022-04-10T21:49:24.1024835Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-10T21:49:24.1069730Z ##[debug]Importing function 'Set-RefreshSchedule'.
2022-04-10T21:49:24.1094050Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2022-04-10T21:49:24.1115440Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2022-04-10T21:49:24.1141282Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2022-04-10T21:49:24.1162198Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2022-04-10T21:49:24.1182345Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-10T21:49:24.1211284Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2022-04-10T21:49:24.1262249Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2022-04-10T21:49:24.1291709Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2022-04-10T21:49:24.1599235Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '46b0eb2e-0fb1-499b-93f2-30d15caf9d66'
2022-04-10T21:49:24.1733816Z ##[debug]ENDPOINT_URL_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: 'https://api.powerbi.com/v1.0/myorg'
2022-04-10T21:49:24.1761912Z ##[debug]ENDPOINT_AUTH_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '********'
2022-04-10T21:49:24.1795538Z ##[debug]ENDPOINT_DATA_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '{"OrganizationType":"Public"}'
2022-04-10T21:49:24.1966294Z ##[debug]{
2022-04-10T21:49:24.1989933Z ##[debug]    "Url":  "https://api.powerbi.com/v1.0/myorg",
2022-04-10T21:49:24.2007798Z ##[debug]    "Data":  {
2022-04-10T21:49:24.2023563Z ##[debug]                 "OrganizationType":  "Public"
2022-04-10T21:49:24.2058855Z ##[debug]             },
2022-04-10T21:49:24.2075130Z ##[debug]    "Auth":  {
2022-04-10T21:49:24.2093089Z ##[debug]                 "parameters":  {
2022-04-10T21:49:24.2113480Z ##[debug]                                    "TenantId":  "59762c14-55e8-4b58-806e-f6cc47d75b19",
2022-04-10T21:49:24.2135997Z ##[debug]                                    "ClientId":  "***",
2022-04-10T21:49:24.2177608Z ##[debug]                                    "ClientSecret":  ***,
2022-04-10T21:49:24.2199792Z ##[debug]                                    "ClientCertificate":  ""
2022-04-10T21:49:24.2212824Z ##[debug]                                },
2022-04-10T21:49:24.2228529Z ##[debug]                 "scheme":  "None"
2022-04-10T21:49:24.2276788Z ##[debug]             }
2022-04-10T21:49:24.2296426Z ##[debug]}
2022-04-10T21:49:24.5330840Z ##[debug]9:49:24 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2022-04-10T21:49:24.5331870Z ##[debug]9:49:24 PM - Cmdlet version: 1.2.1077.0
2022-04-10T21:49:24.5752158Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/59762c14-55e8-4b58-806e-f6cc47d75b19
2022-04-10T21:49:24.6813320Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24] Found 0 cache accounts and 0 broker accounts
2022-04-10T21:49:24.6904727Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d)
2022-04-10T21:49:24.6971005Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] === AcquireTokenForClientParameters ===
2022-04-10T21:49:24.6989481Z ##[debug]SendX5C: False
2022-04-10T21:49:24.7014850Z ##[debug]WithAzureRegion: False
2022-04-10T21:49:24.7035088Z ##[debug]RegionToUse: 
2022-04-10T21:49:24.7054437Z ##[debug]ForceRefresh: False
2022-04-10T21:49:24.7073474Z ##[debug]
2022-04-10T21:49:24.7228666Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] 
2022-04-10T21:49:24.7259387Z ##[debug]=== Request Data ===
2022-04-10T21:49:24.7279533Z ##[debug]Authority Provided? - True
2022-04-10T21:49:24.7317869Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-10T21:49:24.7338372Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-10T21:49:24.7357222Z ##[debug]ApiId - AcquireTokenForClient
2022-04-10T21:49:24.7376452Z ##[debug]IsConfidentialClient - True
2022-04-10T21:49:24.7414109Z ##[debug]SendX5C - False
2022-04-10T21:49:24.7432677Z ##[debug]LoginHint ? False
2022-04-10T21:49:24.7448698Z ##[debug]IsBrokerConfigured - False
2022-04-10T21:49:24.7471862Z ##[debug]HomeAccountId - False
2022-04-10T21:49:24.7502966Z ##[debug]CorrelationId - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d
2022-04-10T21:49:24.7503942Z ##[debug]
2022-04-10T21:49:24.7535857Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] === Token Acquisition (ClientCredentialRequest) started:
2022-04-10T21:49:24.7551117Z ##[debug]  
2022-04-10T21:49:24.7598733Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-10T21:49:24.8139965Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:24 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Fetching instance discovery from the network from host login.microsoftonline.com. 
2022-04-10T21:49:25.3082710Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Resolving authority endpoints... Already resolved? - FALSE
2022-04-10T21:49:25.3137645Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] ScopeSet was missing from the token response, so using developer provided scopes in the result. 
2022-04-10T21:49:25.3163321Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Checking client info returned from the server..
2022-04-10T21:49:25.3184980Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Saving Token Response to cache..
2022-04-10T21:49:25.3216249Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] ID Token not present in response. 
2022-04-10T21:49:25.3256872Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Saving AT in cache and removing overlapping ATs...
2022-04-10T21:49:25.3279489Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2022-04-10T21:49:25.3326117Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] Intersecting scope entries count - 0
2022-04-10T21:49:25.3351474Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 7bd4d7f7-b4a9-4277-bc57-cfc76d131f8d] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/10/2022 22:49:24 +00:00 ===
2022-04-10T21:49:25.3388410Z ##[debug]9:49:25 PM - Connect-PowerBIServiceAccount end processing.
2022-04-10T21:49:25.3434933Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s\**.pbix'
2022-04-10T21:49:25.3479943Z ##[debug]INPUT_WORKSPACENAME: 'PBI - DevOPS - DEV/QA'
2022-04-10T21:49:25.3544814Z ##[debug]INPUT_OVERWRITE: 'true'
2022-04-10T21:49:25.3627046Z ##[debug] Converted to bool: True
2022-04-10T21:49:25.3677086Z ##[debug]INPUT_CREATE: 'true'
2022-04-10T21:49:25.3706184Z ##[debug] Converted to bool: True
2022-04-10T21:49:25.3755632Z ##[debug]INPUT_ACTION: 'Publish'
2022-04-10T21:49:25.3816040Z ##[debug]INPUT_DATASETNAME (empty)
2022-04-10T21:49:25.3867187Z ##[debug]INPUT_OLDURL (empty)
2022-04-10T21:49:25.3929565Z ##[debug]INPUT_NEWURL (empty)
2022-04-10T21:49:25.3992748Z ##[debug]INPUT_OLDSERVER (empty)
2022-04-10T21:49:25.4044470Z ##[debug]INPUT_NEWSERVER (empty)
2022-04-10T21:49:25.4077973Z ##[debug]INPUT_OLDDATABASE (empty)
2022-04-10T21:49:25.4108999Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2022-04-10T21:49:25.4136314Z ##[debug]INPUT_NEWDATABASE (empty)
2022-04-10T21:49:25.4181188Z ##[debug]INPUT_PERMISSION (empty)
2022-04-10T21:49:25.4214078Z ##[debug]INPUT_USERS (empty)
2022-04-10T21:49:25.4246521Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2022-04-10T21:49:25.4282193Z ##[debug]INPUT_UPDATEALL: 'false'
2022-04-10T21:49:25.4307950Z ##[debug] Converted to bool: False
2022-04-10T21:49:25.4345349Z ##[debug]INPUT_SKIPREPORT: 'true'
2022-04-10T21:49:25.4370882Z ##[debug] Converted to bool: True
2022-04-10T21:49:25.4407487Z ##[debug]INPUT_INDIVIDUAL (empty)
2022-04-10T21:49:25.4468352Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2022-04-10T21:49:25.4506268Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2022-04-10T21:49:25.4533430Z ##[debug]INPUT_PARAMETERINPUT (empty)
2022-04-10T21:49:25.4826691Z ##[debug]INPUT_GATEWAYNAME (empty)
2022-04-10T21:49:25.4887886Z ##[debug]INPUT_REPORTNAME (empty)
2022-04-10T21:49:25.4912910Z ##[debug]INPUT_CAPACITYNAME (empty)
2022-04-10T21:49:25.4942631Z ##[debug]INPUT_USERNAME (empty)
2022-04-10T21:49:25.4983755Z ##[debug]INPUT_PASSWORD (empty)
2022-04-10T21:49:25.5024250Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2022-04-10T21:49:25.5082290Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2022-04-10T21:49:25.5141739Z ##[debug] Converted to bool: False
2022-04-10T21:49:25.5173652Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2022-04-10T21:49:25.5186054Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2022-04-10T21:49:25.5276213Z ##[debug]WorkspaceName         : PBI - DevOPS - DEV/QA
2022-04-10T21:49:25.5299920Z ##[debug]Create                : True
2022-04-10T21:49:25.5327864Z ##[debug]File patern             : D:\a\1\s\**.pbix
2022-04-10T21:49:25.5388734Z ##[debug]Remove report           : True
2022-04-10T21:49:25.5889856Z Getting Power BI Workspace properties; PBI - DevOPS - DEV/QA
2022-04-10T21:49:25.6055981Z ##[debug]9:49:25 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-10T21:49:25.6103623Z ##[debug]9:49:25 PM - Cmdlet version: 1.2.1077.0
2022-04-10T21:49:25.6339238Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25] Found 0 cache accounts and 0 broker accounts
2022-04-10T21:49:25.6395146Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(638de817-037a-4292-82bf-8674f052cc42)
2022-04-10T21:49:25.6450220Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] === AcquireTokenForClientParameters ===
2022-04-10T21:49:25.6536810Z ##[debug]SendX5C: False
2022-04-10T21:49:25.6557172Z ##[debug]WithAzureRegion: False
2022-04-10T21:49:25.6575576Z ##[debug]RegionToUse: 
2022-04-10T21:49:25.6611508Z ##[debug]ForceRefresh: False
2022-04-10T21:49:25.6627181Z ##[debug]
2022-04-10T21:49:25.6652415Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] 
2022-04-10T21:49:25.6668411Z ##[debug]=== Request Data ===
2022-04-10T21:49:25.6684940Z ##[debug]Authority Provided? - True
2022-04-10T21:49:25.6701039Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-10T21:49:25.6719695Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-10T21:49:25.6744013Z ##[debug]ApiId - AcquireTokenForClient
2022-04-10T21:49:25.6793156Z ##[debug]IsConfidentialClient - True
2022-04-10T21:49:25.6809820Z ##[debug]SendX5C - False
2022-04-10T21:49:25.6833254Z ##[debug]LoginHint ? False
2022-04-10T21:49:25.6848549Z ##[debug]IsBrokerConfigured - False
2022-04-10T21:49:25.6863388Z ##[debug]HomeAccountId - False
2022-04-10T21:49:25.6879015Z ##[debug]CorrelationId - 638de817-037a-4292-82bf-8674f052cc42
2022-04-10T21:49:25.6895404Z ##[debug]
2022-04-10T21:49:25.6977793Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] === Token Acquisition (ClientCredentialRequest) started:
2022-04-10T21:49:25.7031790Z ##[debug]  
2022-04-10T21:49:25.7064472Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-10T21:49:25.7149137Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] Access token is not expired. Returning the found cache entry. [Current time (04/10/2022 21:49:25) - Expiration Time (04/10/2022 22:49:24 +00:00) - Extended Expiration Time (04/10/2022 22:49:24 +00:00)]
2022-04-10T21:49:25.7233267Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:25 - 638de817-037a-4292-82bf-8674f052cc42] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/10/2022 22:49:24 +00:00 ===
2022-04-10T21:49:26.2240465Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi - devops - dev/qa'&$top=100
2022-04-10T21:49:26.2270682Z ##[debug]Status Code: OK (200)
2022-04-10T21:49:26.2364606Z ##[debug]9:49:26 PM - Get-PowerBIWorkspace end processing.
2022-04-10T21:49:26.2482646Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]ba8159af-9cf0-4f44-ba1a-3308e266b550
2022-04-10T21:49:26.2574630Z Trying to publish PowerBI File: D:\a\1\s\Today’s Sales DEV.pbix
2022-04-10T21:49:26.2616573Z Checking for existing Reports with the name: Today’s Sales DEV
2022-04-10T21:49:26.2726580Z ##[debug]9:49:26 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-10T21:49:26.2750136Z ##[debug]9:49:26 PM - Cmdlet version: 1.2.1077.0
2022-04-10T21:49:26.2779277Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26] Found 0 cache accounts and 0 broker accounts
2022-04-10T21:49:26.2835466Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(ccf491ff-41de-44f3-b815-90f569090a79)
2022-04-10T21:49:26.2869267Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] === AcquireTokenForClientParameters ===
2022-04-10T21:49:26.2933744Z ##[debug]SendX5C: False
2022-04-10T21:49:26.2952867Z ##[debug]WithAzureRegion: False
2022-04-10T21:49:26.2968167Z ##[debug]RegionToUse: 
2022-04-10T21:49:26.3009144Z ##[debug]ForceRefresh: False
2022-04-10T21:49:26.3025514Z ##[debug]
2022-04-10T21:49:26.3106943Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] 
2022-04-10T21:49:26.3124776Z ##[debug]=== Request Data ===
2022-04-10T21:49:26.3143118Z ##[debug]Authority Provided? - True
2022-04-10T21:49:26.3163641Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-10T21:49:26.3181133Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-10T21:49:26.3197217Z ##[debug]ApiId - AcquireTokenForClient
2022-04-10T21:49:26.3216554Z ##[debug]IsConfidentialClient - True
2022-04-10T21:49:26.3275777Z ##[debug]SendX5C - False
2022-04-10T21:49:26.3296856Z ##[debug]LoginHint ? False
2022-04-10T21:49:26.3330171Z ##[debug]IsBrokerConfigured - False
2022-04-10T21:49:26.3375429Z ##[debug]HomeAccountId - False
2022-04-10T21:49:26.3394795Z ##[debug]CorrelationId - ccf491ff-41de-44f3-b815-90f569090a79
2022-04-10T21:49:26.3411761Z ##[debug]
2022-04-10T21:49:26.3437125Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] === Token Acquisition (ClientCredentialRequest) started:
2022-04-10T21:49:26.3453140Z ##[debug]  
2022-04-10T21:49:26.3469133Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-10T21:49:26.3495512Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] Access token is not expired. Returning the found cache entry. [Current time (04/10/2022 21:49:26) - Expiration Time (04/10/2022 22:49:24 +00:00) - Extended Expiration Time (04/10/2022 22:49:24 +00:00)]
2022-04-10T21:49:26.3527216Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - ccf491ff-41de-44f3-b815-90f569090a79] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/10/2022 22:49:24 +00:00 ===
2022-04-10T21:49:26.3552112Z ##[debug]9:49:26 PM - Get-PowerBIAccessToken end processing.
2022-04-10T21:49:26.3584430Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports
2022-04-10T21:49:26.3675836Z ##[debug]GET https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports with 0-byte payload
2022-04-10T21:49:26.7002490Z ##[debug]received -1-byte response of content type application/json; odata.metadata=minimal; odata.streaming=true
2022-04-10T21:49:26.7156751Z ##[debug]Trying to find report 'Today’s Sales DEV'
2022-04-10T21:49:26.7271549Z Importing PowerBI File
2022-04-10T21:49:26.8655667Z ##[debug]9:49:26 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-10T21:49:26.8677805Z ##[debug]9:49:26 PM - Cmdlet version: 1.2.1077.0
2022-04-10T21:49:26.8728429Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26] Found 0 cache accounts and 0 broker accounts
2022-04-10T21:49:26.8750432Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(63a8cb23-c4b1-4c99-92c5-9d836d3aacf2)
2022-04-10T21:49:26.8781248Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] === AcquireTokenForClientParameters ===
2022-04-10T21:49:26.8865469Z ##[debug]SendX5C: False
2022-04-10T21:49:26.8884968Z ##[debug]WithAzureRegion: False
2022-04-10T21:49:26.8907740Z ##[debug]RegionToUse: 
2022-04-10T21:49:26.8926315Z ##[debug]ForceRefresh: False
2022-04-10T21:49:26.8954701Z ##[debug]
2022-04-10T21:49:26.9038909Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] 
2022-04-10T21:49:26.9055188Z ##[debug]=== Request Data ===
2022-04-10T21:49:26.9071954Z ##[debug]Authority Provided? - True
2022-04-10T21:49:26.9092770Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-10T21:49:26.9109141Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-10T21:49:26.9138080Z ##[debug]ApiId - AcquireTokenForClient
2022-04-10T21:49:26.9166537Z ##[debug]IsConfidentialClient - True
2022-04-10T21:49:26.9201464Z ##[debug]SendX5C - False
2022-04-10T21:49:26.9213108Z ##[debug]LoginHint ? False
2022-04-10T21:49:26.9248688Z ##[debug]IsBrokerConfigured - False
2022-04-10T21:49:26.9265108Z ##[debug]HomeAccountId - False
2022-04-10T21:49:26.9324854Z ##[debug]CorrelationId - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2
2022-04-10T21:49:26.9350362Z ##[debug]
2022-04-10T21:49:26.9380635Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] === Token Acquisition (ClientCredentialRequest) started:
2022-04-10T21:49:26.9429638Z ##[debug]  
2022-04-10T21:49:26.9446205Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-10T21:49:26.9472360Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] Access token is not expired. Returning the found cache entry. [Current time (04/10/2022 21:49:26) - Expiration Time (04/10/2022 22:49:24 +00:00) - Extended Expiration Time (04/10/2022 22:49:24 +00:00)]
2022-04-10T21:49:26.9528998Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/10/2022 21:49:26 - 63a8cb23-c4b1-4c99-92c5-9d836d3aacf2] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/10/2022 22:49:24 +00:00 ===
2022-04-10T21:49:26.9550043Z ##[debug]9:49:26 PM - Get-PowerBIAccessToken end processing.
2022-04-10T21:49:26.9572646Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=Today%e2%80%99s+Sales+DEV.pbix&nameConflict=Abort&skipReport=True
2022-04-10T21:49:27.0592283Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=Today’s+Sales+DEV.pbix&nameConflict=Abort&skipReport=True with -1-byte payload
2022-04-10T21:49:27.7573948Z Done processing Power BI Actions
2022-04-10T21:49:27.7686499Z ##[debug]Caught exception from task script.
2022-04-10T21:49:27.7729577Z ##[debug]Error record:
2022-04-10T21:49:27.8467704Z ##[debug]Invoke-API : The remote server returned an error: (400) Bad Request.
2022-04-10T21:49:27.8484861Z ##[debug]At D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:655 char:15
2022-04-10T21:49:27.8502042Z ##[debug]+ ...   $result = Invoke-API -Url $url -Method "Post" -Body $body -ContentT ...
2022-04-10T21:49:27.8520197Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-04-10T21:49:27.8552251Z ##[debug]    + CategoryInfo          : NotSpecified: (:) [Write-Error], WebException
2022-04-10T21:49:27.8590104Z ##[debug]    + FullyQualifiedErrorId : System.Net.WebException,Invoke-API
2022-04-10T21:49:27.8621163Z ##[debug] 
2022-04-10T21:49:27.8651006Z ##[debug]Script stack trace:
2022-04-10T21:49:27.8692459Z ##[debug]at Invoke-API, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 311
2022-04-10T21:49:27.8750648Z ##[debug]at Import-PowerBIFile, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 655
2022-04-10T21:49:27.8770637Z ##[debug]at Publish-PowerBIFileApi, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 862
2022-04-10T21:49:27.8790433Z ##[debug]at <ScriptBlock><Process>, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1: line 102
2022-04-10T21:49:27.8814563Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-10T21:49:27.8833228Z ##[debug]at <ScriptBlock>, <No file>: line 22
2022-04-10T21:49:27.8848657Z ##[debug]at <ScriptBlock>, <No file>: line 18
2022-04-10T21:49:27.8869920Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-10T21:49:27.8893240Z ##[debug]Exception:
2022-04-10T21:49:27.8974215Z ##[debug]System.Net.WebException: The remote server returned an error: (400) Bad Request.
2022-04-10T21:49:27.8990987Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
2022-04-10T21:49:27.9031247Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
2022-04-10T21:49:27.9317903Z ##[error]The remote server returned an error: (400) Bad Request.
2022-04-10T21:49:27.9327311Z ##[debug]Processed: ##vso[task.logissue type=error]The remote server returned an error: (400) Bad Request.
2022-04-10T21:49:27.9334129Z ##[debug]Processed: ##vso[task.complete result=Failed]
2022-04-10T21:49:27.9828612Z ##[section]Finishing: Power BI Action: Publish
maikvandergaag commented 2 years ago

Ok, I think I see the problem. Could you try the following as a test?

lululorcan commented 2 years ago

I changed the pbix file name from 'Today's Sales DEV.pbix' to '.pbix' - same error:

2022-04-11T17:16:32.7693398Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish'
2022-04-11T17:16:32.7695295Z ##[debug]Evaluating: SucceededNode()
2022-04-11T17:16:32.7695760Z ##[debug]Evaluating SucceededNode:
2022-04-11T17:16:32.7696882Z ##[debug]=> True
2022-04-11T17:16:32.7697372Z ##[debug]Result: True
2022-04-11T17:16:32.7697768Z ##[section]Starting: Power BI Action: Publish
2022-04-11T17:16:32.7810755Z ==============================================================================
2022-04-11T17:16:32.7811027Z Task         : Power BI Actions
2022-04-11T17:16:32.7811227Z Description  : Release Task Power BI Actions
2022-04-11T17:16:32.7811412Z Version      : 5.4.31
2022-04-11T17:16:32.7811578Z Author       : Maik van der Gaag
2022-04-11T17:16:32.7811737Z Help         : 
2022-04-11T17:16:32.7811946Z ==============================================================================
2022-04-11T17:16:39.4116996Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2022-04-11T17:16:42.8572738Z Starting Power BI Actions extension
2022-04-11T17:16:42.8691155Z ##[debug]Entering D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1.
2022-04-11T17:16:42.8756232Z ### Required Module is needed. Importing now...
2022-04-11T17:16:42.8797085Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2022-04-11T17:16:42.8861008Z ##[debug]Loading 'TypesToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2022-04-11T17:16:43.4073824Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2022-04-11T17:16:43.9402200Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2022-04-11T17:16:43.9426119Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2022-04-11T17:16:43.9505556Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-11T17:16:43.9543580Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-11T17:16:43.9544747Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2022-04-11T17:16:43.9550832Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-11T17:16:43.9563203Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2022-04-11T17:16:43.9579012Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-11T17:16:43.9593059Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-11T17:16:43.9607674Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2022-04-11T17:16:43.9622371Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-11T17:16:43.9636625Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2022-04-11T17:16:43.9650907Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2022-04-11T17:16:43.9664900Z ##[debug]Importing alias 'Login-PowerBI'.
2022-04-11T17:16:43.9679279Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2022-04-11T17:16:43.9693396Z ##[debug]Importing alias 'Logout-PowerBI'.
2022-04-11T17:16:43.9707875Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2022-04-11T17:16:43.9721708Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2022-04-11T17:16:43.9736082Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2022-04-11T17:16:43.9764357Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2022-04-11T17:16:43.9818641Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2022-04-11T17:16:43.9991516Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2022-04-11T17:16:44.0063771Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2022-04-11T17:16:44.0077340Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-11T17:16:44.0166274Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2022-04-11T17:16:44.1113089Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-11T17:16:44.1116009Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2022-04-11T17:16:44.1136499Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-11T17:16:44.1152814Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2022-04-11T17:16:44.1169757Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2022-04-11T17:16:44.1184214Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-11T17:16:44.1198467Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2022-04-11T17:16:44.1210942Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-11T17:16:44.1215654Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2022-04-11T17:16:44.1230164Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-11T17:16:44.1246055Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2022-04-11T17:16:44.1260092Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2022-04-11T17:16:44.1274799Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2022-04-11T17:16:44.1288950Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2022-04-11T17:16:44.1303353Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2022-04-11T17:16:44.1317231Z ##[debug]Importing alias 'New-PowerBIGroup'.
2022-04-11T17:16:44.1331435Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2022-04-11T17:16:44.1345303Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2022-04-11T17:16:44.1359358Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2022-04-11T17:16:44.1389310Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2022-04-11T17:16:44.1446789Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2022-04-11T17:16:44.1469853Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2022-04-11T17:16:44.1517567Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2022-04-11T17:16:44.1531836Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2022-04-11T17:16:44.1546394Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2022-04-11T17:16:44.1560603Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2022-04-11T17:16:44.1575029Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2022-04-11T17:16:44.1589253Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2022-04-11T17:16:44.1603474Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2022-04-11T17:16:44.1617397Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2022-04-11T17:16:44.1631451Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2022-04-11T17:16:44.1645658Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2022-04-11T17:16:44.1660047Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2022-04-11T17:16:44.1674069Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2022-04-11T17:16:44.1688322Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2022-04-11T17:16:44.1702244Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2022-04-11T17:16:44.1716510Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2022-04-11T17:16:44.1730384Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2022-04-11T17:16:44.1744146Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2022-04-11T17:16:44.1758520Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2022-04-11T17:16:44.1772446Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2022-04-11T17:16:44.8040703Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2022-04-11T17:16:44.8041333Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2022-04-11T17:16:44.8042097Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2022-04-11T17:16:44.8043112Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2022-04-11T17:16:44.8043961Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2022-04-11T17:16:44.8044827Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2022-04-11T17:16:44.8045609Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2022-04-11T17:16:44.8046139Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2022-04-11T17:16:44.8046670Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2022-04-11T17:16:44.8047205Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2022-04-11T17:16:44.8047850Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-11T17:16:44.8048410Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2022-04-11T17:16:44.8048958Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2022-04-11T17:16:44.8049488Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2022-04-11T17:16:44.8050015Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2022-04-11T17:16:44.8050536Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2022-04-11T17:16:44.8051071Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2022-04-11T17:16:44.8051605Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2022-04-11T17:16:44.8052127Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2022-04-11T17:16:44.8052647Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2022-04-11T17:16:44.8053168Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2022-04-11T17:16:44.8053684Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2022-04-11T17:16:44.8054212Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2022-04-11T17:16:44.8054739Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2022-04-11T17:16:44.8055275Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-11T17:16:44.8055814Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2022-04-11T17:16:44.8056341Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2022-04-11T17:16:44.8056874Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2022-04-11T17:16:44.8057390Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2022-04-11T17:16:44.8058174Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2022-04-11T17:16:44.8058687Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2022-04-11T17:16:44.8059204Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2022-04-11T17:16:44.8059765Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2022-04-11T17:16:44.8060282Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2022-04-11T17:16:44.8060673Z ### Trying to import the incorporated module for PowerBI
2022-04-11T17:16:44.8061291Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1'.
2022-04-11T17:16:47.6151114Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-11T17:16:47.6166634Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-11T17:16:47.6181808Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2022-04-11T17:16:47.6209467Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-11T17:16:47.6224134Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2022-04-11T17:16:47.6238629Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2022-04-11T17:16:47.6242460Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2022-04-11T17:16:47.6258083Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2022-04-11T17:16:47.6272551Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2022-04-11T17:16:47.6287529Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2022-04-11T17:16:47.6301560Z ##[debug]Exporting function 'Invoke-API'.
2022-04-11T17:16:47.6316615Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2022-04-11T17:16:47.6330715Z ##[debug]Exporting function 'New-DatasetRefresh'.
2022-04-11T17:16:47.6345020Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2022-04-11T17:16:47.6359379Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2022-04-11T17:16:47.6373768Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2022-04-11T17:16:47.6386893Z ##[debug]Exporting function 'Get-PowerBIReport'.
2022-04-11T17:16:47.6426892Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2022-04-11T17:16:47.6427971Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2022-04-11T17:16:47.6442352Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2022-04-11T17:16:47.6454806Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2022-04-11T17:16:47.6462276Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2022-04-11T17:16:47.6473706Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2022-04-11T17:16:47.6489351Z ##[debug]Exporting function 'Import-PowerBIFile'.
2022-04-11T17:16:47.6503466Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2022-04-11T17:16:47.6517999Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2022-04-11T17:16:47.6531966Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2022-04-11T17:16:47.6557650Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2022-04-11T17:16:47.6560442Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2022-04-11T17:16:47.6572230Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2022-04-11T17:16:47.6587147Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2022-04-11T17:16:47.6600942Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2022-04-11T17:16:47.6615202Z ##[debug]Exporting function 'Set-Capacity'.
2022-04-11T17:16:47.6628901Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2022-04-11T17:16:47.6643100Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-11T17:16:47.6656873Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2022-04-11T17:16:47.6671545Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2022-04-11T17:16:47.6685938Z ##[debug]Exporting function 'Publish-TabularEditor'.
2022-04-11T17:16:47.6703140Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2022-04-11T17:16:47.6716613Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2022-04-11T17:16:47.6729610Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2022-04-11T17:16:47.6744152Z ##[debug]Importing function 'Get-PowerBICapacity'.
2022-04-11T17:16:47.6757668Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2022-04-11T17:16:47.6771985Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2022-04-11T17:16:47.6785248Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-11T17:16:47.6798984Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2022-04-11T17:16:47.6813087Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2022-04-11T17:16:47.6826737Z ##[debug]Importing function 'Get-PowerBIGateways'.
2022-04-11T17:16:47.6845890Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2022-04-11T17:16:47.6853290Z ##[debug]Importing function 'Get-PowerBiParameters'.
2022-04-11T17:16:47.6867723Z ##[debug]Importing function 'Get-PowerBIReport'.
2022-04-11T17:16:47.6881510Z ##[debug]Importing function 'Import-PowerBIFile'.
2022-04-11T17:16:47.6895694Z ##[debug]Importing function 'Invoke-API'.
2022-04-11T17:16:47.6909521Z ##[debug]Importing function 'New-DatasetRefresh'.
2022-04-11T17:16:47.6923390Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2022-04-11T17:16:47.6936978Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2022-04-11T17:16:47.6950873Z ##[debug]Importing function 'Publish-PowerBIFile'.
2022-04-11T17:16:47.6973948Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2022-04-11T17:16:47.6976886Z ##[debug]Importing function 'Publish-TabularEditor'.
2022-04-11T17:16:47.6990601Z ##[debug]Importing function 'Redo-PowerBIReport'.
2022-04-11T17:16:47.7005217Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-11T17:16:47.7018771Z ##[debug]Importing function 'Remove-PowerBIReport'.
2022-04-11T17:16:47.7033041Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2022-04-11T17:16:47.7047009Z ##[debug]Importing function 'Set-Capacity'.
2022-04-11T17:16:47.7061260Z ##[debug]Importing function 'Set-DatasetOwnership'.
2022-04-11T17:16:47.7074961Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2022-04-11T17:16:47.7088966Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-11T17:16:47.7105919Z ##[debug]Importing function 'Set-RefreshSchedule'.
2022-04-11T17:16:47.7116855Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2022-04-11T17:16:47.7131156Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2022-04-11T17:16:47.7145053Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2022-04-11T17:16:47.7159024Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2022-04-11T17:16:47.7172632Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-11T17:16:47.7186585Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2022-04-11T17:16:47.7200538Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2022-04-11T17:16:47.7214496Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2022-04-11T17:16:47.7422745Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '46b0eb2e-0fb1-499b-93f2-30d15caf9d66'
2022-04-11T17:16:47.8869653Z ##[debug]ENDPOINT_URL_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: 'https://api.powerbi.com/v1.0/myorg'
2022-04-11T17:16:47.8891525Z ##[debug]ENDPOINT_AUTH_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '********'
2022-04-11T17:16:47.8914128Z ##[debug]ENDPOINT_DATA_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '{"OrganizationType":"Public"}'
2022-04-11T17:16:48.9238134Z ##[debug]{
2022-04-11T17:16:48.9248850Z ##[debug]    "Url":  "https://api.powerbi.com/v1.0/myorg",
2022-04-11T17:16:48.9259057Z ##[debug]    "Data":  {
2022-04-11T17:16:48.9269249Z ##[debug]                 "OrganizationType":  "Public"
2022-04-11T17:16:48.9279175Z ##[debug]             },
2022-04-11T17:16:48.9288987Z ##[debug]    "Auth":  {
2022-04-11T17:16:48.9299004Z ##[debug]                 "parameters":  {
2022-04-11T17:16:48.9308882Z ##[debug]                                    "TenantId":  "59762c14-55e8-4b58-806e-f6cc47d75b19",
2022-04-11T17:16:48.9319536Z ##[debug]                                    "ClientId":  "***",
2022-04-11T17:16:48.9352139Z ##[debug]                                    "ClientSecret":  ***,
2022-04-11T17:16:48.9372832Z ##[debug]                                    "ClientCertificate":  ""
2022-04-11T17:16:48.9373747Z ##[debug]                                },
2022-04-11T17:16:48.9383546Z ##[debug]                 "scheme":  "None"
2022-04-11T17:16:48.9393541Z ##[debug]             }
2022-04-11T17:16:48.9399507Z ##[debug]}
2022-04-11T17:16:49.8330644Z ##[debug]5:16:49 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2022-04-11T17:16:49.8349203Z ##[debug]5:16:49 PM - Cmdlet version: 1.2.1077.0
2022-04-11T17:16:49.8652993Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/59762c14-55e8-4b58-806e-f6cc47d75b19
2022-04-11T17:16:51.4497954Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51] Found 0 cache accounts and 0 broker accounts
2022-04-11T17:16:51.4561305Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(89e00f7f-e4ed-48a4-a8f8-35259bd00e56)
2022-04-11T17:16:51.4607899Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] === AcquireTokenForClientParameters ===
2022-04-11T17:16:51.4608956Z ##[debug]SendX5C: False
2022-04-11T17:16:51.4615505Z ##[debug]WithAzureRegion: False
2022-04-11T17:16:51.4626438Z ##[debug]RegionToUse: 
2022-04-11T17:16:51.4636613Z ##[debug]ForceRefresh: False
2022-04-11T17:16:51.4646610Z ##[debug]
2022-04-11T17:16:51.4761834Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] 
2022-04-11T17:16:51.4771371Z ##[debug]=== Request Data ===
2022-04-11T17:16:51.4782077Z ##[debug]Authority Provided? - True
2022-04-11T17:16:51.4791759Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T17:16:51.4801859Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T17:16:51.4811555Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T17:16:51.4821380Z ##[debug]IsConfidentialClient - True
2022-04-11T17:16:51.4830950Z ##[debug]SendX5C - False
2022-04-11T17:16:51.4846517Z ##[debug]LoginHint ? False
2022-04-11T17:16:51.4855991Z ##[debug]IsBrokerConfigured - False
2022-04-11T17:16:51.4859026Z ##[debug]HomeAccountId - False
2022-04-11T17:16:51.4868759Z ##[debug]CorrelationId - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56
2022-04-11T17:16:51.4878351Z ##[debug]
2022-04-11T17:16:51.4903694Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T17:16:51.4912899Z ##[debug]  
2022-04-11T17:16:51.4923110Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T17:16:51.5225969Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:51 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Fetching instance discovery from the network from host login.microsoftonline.com. 
2022-04-11T17:16:55.0921238Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:53 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Resolving authority endpoints... Already resolved? - FALSE
2022-04-11T17:16:55.0936193Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] ScopeSet was missing from the token response, so using developer provided scopes in the result. 
2022-04-11T17:16:55.0953043Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Checking client info returned from the server..
2022-04-11T17:16:55.0964191Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Saving Token Response to cache..
2022-04-11T17:16:55.0999682Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] ID Token not present in response. 
2022-04-11T17:16:55.1025496Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Saving AT in cache and removing overlapping ATs...
2022-04-11T17:16:55.1027028Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2022-04-11T17:16:55.1030975Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] Intersecting scope entries count - 0
2022-04-11T17:16:55.1045738Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 89e00f7f-e4ed-48a4-a8f8-35259bd00e56] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 18:16:54 +00:00 ===
2022-04-11T17:16:55.1061944Z ##[debug]5:16:55 PM - Connect-PowerBIServiceAccount end processing.
2022-04-11T17:16:55.1080681Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s\**.pbix'
2022-04-11T17:16:55.1098589Z ##[debug]INPUT_WORKSPACENAME: 'PBI - DevOPS - DEV/QA'
2022-04-11T17:16:55.1119087Z ##[debug]INPUT_OVERWRITE: 'true'
2022-04-11T17:16:55.1146215Z ##[debug] Converted to bool: True
2022-04-11T17:16:55.1163253Z ##[debug]INPUT_CREATE: 'true'
2022-04-11T17:16:55.1177090Z ##[debug] Converted to bool: True
2022-04-11T17:16:55.1194877Z ##[debug]INPUT_ACTION: 'Publish'
2022-04-11T17:16:55.1212315Z ##[debug]INPUT_DATASETNAME (empty)
2022-04-11T17:16:55.1248886Z ##[debug]INPUT_OLDURL (empty)
2022-04-11T17:16:55.1265707Z ##[debug]INPUT_NEWURL (empty)
2022-04-11T17:16:55.1282951Z ##[debug]INPUT_OLDSERVER (empty)
2022-04-11T17:16:55.1304973Z ##[debug]INPUT_NEWSERVER (empty)
2022-04-11T17:16:55.1315420Z ##[debug]INPUT_OLDDATABASE (empty)
2022-04-11T17:16:55.1332585Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2022-04-11T17:16:55.1349191Z ##[debug]INPUT_NEWDATABASE (empty)
2022-04-11T17:16:55.1366686Z ##[debug]INPUT_PERMISSION (empty)
2022-04-11T17:16:55.1383025Z ##[debug]INPUT_USERS (empty)
2022-04-11T17:16:55.1400517Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2022-04-11T17:16:55.1432697Z ##[debug]INPUT_UPDATEALL: 'false'
2022-04-11T17:16:55.1433459Z ##[debug] Converted to bool: False
2022-04-11T17:16:55.1445692Z ##[debug]INPUT_SKIPREPORT: 'true'
2022-04-11T17:16:55.1459614Z ##[debug] Converted to bool: True
2022-04-11T17:16:55.1476080Z ##[debug]INPUT_INDIVIDUAL (empty)
2022-04-11T17:16:55.1493239Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2022-04-11T17:16:55.1510114Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2022-04-11T17:16:55.1526975Z ##[debug]INPUT_PARAMETERINPUT (empty)
2022-04-11T17:16:55.1543735Z ##[debug]INPUT_GATEWAYNAME (empty)
2022-04-11T17:16:55.1570621Z ##[debug]INPUT_REPORTNAME (empty)
2022-04-11T17:16:55.1576435Z ##[debug]INPUT_CAPACITYNAME (empty)
2022-04-11T17:16:55.1593566Z ##[debug]INPUT_USERNAME (empty)
2022-04-11T17:16:55.1610330Z ##[debug]INPUT_PASSWORD (empty)
2022-04-11T17:16:55.1808474Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2022-04-11T17:16:55.3700214Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2022-04-11T17:16:55.3719580Z ##[debug] Converted to bool: False
2022-04-11T17:16:55.3738137Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2022-04-11T17:16:55.3782485Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2022-04-11T17:16:55.3796534Z ##[debug]WorkspaceName         : PBI - DevOPS - DEV/QA
2022-04-11T17:16:55.3807676Z ##[debug]Create                : True
2022-04-11T17:16:55.3816949Z ##[debug]File patern             : D:\a\1\s\**.pbix
2022-04-11T17:16:55.3831417Z ##[debug]Remove report           : True
2022-04-11T17:16:55.4058742Z Getting Power BI Workspace properties; PBI - DevOPS - DEV/QA
2022-04-11T17:16:55.4110775Z ##[debug]5:16:55 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-11T17:16:55.4195487Z ##[debug]5:16:55 PM - Cmdlet version: 1.2.1077.0
2022-04-11T17:16:55.7931968Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55] Found 0 cache accounts and 0 broker accounts
2022-04-11T17:16:55.7948089Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4e3effc2-d21f-409e-b72e-24bfdecf2a6b)
2022-04-11T17:16:55.7963224Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] === AcquireTokenForClientParameters ===
2022-04-11T17:16:55.7973393Z ##[debug]SendX5C: False
2022-04-11T17:16:55.7983624Z ##[debug]WithAzureRegion: False
2022-04-11T17:16:55.7993760Z ##[debug]RegionToUse: 
2022-04-11T17:16:55.8008804Z ##[debug]ForceRefresh: False
2022-04-11T17:16:55.8022061Z ##[debug]
2022-04-11T17:16:55.8030504Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] 
2022-04-11T17:16:55.8040000Z ##[debug]=== Request Data ===
2022-04-11T17:16:55.8049395Z ##[debug]Authority Provided? - True
2022-04-11T17:16:55.8058912Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T17:16:55.8068561Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T17:16:55.8078284Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T17:16:55.8087774Z ##[debug]IsConfidentialClient - True
2022-04-11T17:16:55.8097587Z ##[debug]SendX5C - False
2022-04-11T17:16:55.8107220Z ##[debug]LoginHint ? False
2022-04-11T17:16:55.8123468Z ##[debug]IsBrokerConfigured - False
2022-04-11T17:16:55.8132076Z ##[debug]HomeAccountId - False
2022-04-11T17:16:55.8135829Z ##[debug]CorrelationId - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b
2022-04-11T17:16:55.8145176Z ##[debug]
2022-04-11T17:16:55.8159564Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T17:16:55.8168939Z ##[debug]  
2022-04-11T17:16:55.8178781Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T17:16:55.8227693Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 17:16:55) - Expiration Time (04/11/2022 18:16:54 +00:00) - Extended Expiration Time (04/11/2022 18:16:54 +00:00)]
2022-04-11T17:16:55.8250811Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:55 - 4e3effc2-d21f-409e-b72e-24bfdecf2a6b] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 18:16:54 +00:00 ===
2022-04-11T17:16:57.9190092Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi - devops - dev/qa'&$top=100
2022-04-11T17:16:57.9204685Z ##[debug]Status Code: OK (200)
2022-04-11T17:16:57.9219107Z ##[debug]5:16:57 PM - Get-PowerBIWorkspace end processing.
2022-04-11T17:16:57.9282855Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]ba8159af-9cf0-4f44-ba1a-3308e266b550
2022-04-11T17:16:57.9345410Z Trying to publish PowerBI File: D:\a\1\s\.pbix
2022-04-11T17:16:57.9383178Z Checking for existing Reports with the name: 
2022-04-11T17:16:57.9473415Z ##[debug]5:16:57 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-11T17:16:57.9494347Z ##[debug]5:16:57 PM - Cmdlet version: 1.2.1077.0
2022-04-11T17:16:57.9506461Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57] Found 0 cache accounts and 0 broker accounts
2022-04-11T17:16:57.9520955Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(c5878fca-53e6-4e19-922b-9e19c8f97681)
2022-04-11T17:16:57.9534759Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] === AcquireTokenForClientParameters ===
2022-04-11T17:16:57.9544391Z ##[debug]SendX5C: False
2022-04-11T17:16:57.9554305Z ##[debug]WithAzureRegion: False
2022-04-11T17:16:57.9563966Z ##[debug]RegionToUse: 
2022-04-11T17:16:57.9573669Z ##[debug]ForceRefresh: False
2022-04-11T17:16:57.9583189Z ##[debug]
2022-04-11T17:16:57.9597203Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] 
2022-04-11T17:16:57.9619279Z ##[debug]=== Request Data ===
2022-04-11T17:16:57.9619924Z ##[debug]Authority Provided? - True
2022-04-11T17:16:57.9621910Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T17:16:57.9631727Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T17:16:57.9641200Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T17:16:57.9650769Z ##[debug]IsConfidentialClient - True
2022-04-11T17:16:57.9660077Z ##[debug]SendX5C - False
2022-04-11T17:16:57.9669568Z ##[debug]LoginHint ? False
2022-04-11T17:16:57.9678820Z ##[debug]IsBrokerConfigured - False
2022-04-11T17:16:57.9688297Z ##[debug]HomeAccountId - False
2022-04-11T17:16:57.9697678Z ##[debug]CorrelationId - c5878fca-53e6-4e19-922b-9e19c8f97681
2022-04-11T17:16:57.9706937Z ##[debug]
2022-04-11T17:16:57.9720808Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T17:16:57.9730026Z ##[debug]  
2022-04-11T17:16:57.9739623Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T17:16:57.9754020Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 17:16:57) - Expiration Time (04/11/2022 18:16:54 +00:00) - Extended Expiration Time (04/11/2022 18:16:54 +00:00)]
2022-04-11T17:16:57.9777803Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:16:57 - c5878fca-53e6-4e19-922b-9e19c8f97681] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 18:16:54 +00:00 ===
2022-04-11T17:16:57.9781575Z ##[debug]5:16:57 PM - Get-PowerBIAccessToken end processing.
2022-04-11T17:16:57.9803824Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports
2022-04-11T17:16:57.9853209Z ##[debug]GET https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports with 0-byte payload
2022-04-11T17:16:58.1948264Z ##[debug]received -1-byte response of content type application/json; odata.metadata=minimal; odata.streaming=true
2022-04-11T17:16:58.2012953Z Importing PowerBI File
2022-04-11T17:17:00.2306596Z ##[debug]5:17:00 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-11T17:17:00.2320760Z ##[debug]5:17:00 PM - Cmdlet version: 1.2.1077.0
2022-04-11T17:17:00.2325080Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00] Found 0 cache accounts and 0 broker accounts
2022-04-11T17:17:00.2339953Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792)
2022-04-11T17:17:00.2353674Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] === AcquireTokenForClientParameters ===
2022-04-11T17:17:00.2363451Z ##[debug]SendX5C: False
2022-04-11T17:17:00.2373211Z ##[debug]WithAzureRegion: False
2022-04-11T17:17:00.2382836Z ##[debug]RegionToUse: 
2022-04-11T17:17:00.2392508Z ##[debug]ForceRefresh: False
2022-04-11T17:17:00.2402045Z ##[debug]
2022-04-11T17:17:00.2421678Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] 
2022-04-11T17:17:00.2424148Z ##[debug]=== Request Data ===
2022-04-11T17:17:00.2433831Z ##[debug]Authority Provided? - True
2022-04-11T17:17:00.2443488Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T17:17:00.2452873Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T17:17:00.2462804Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T17:17:00.2472249Z ##[debug]IsConfidentialClient - True
2022-04-11T17:17:00.2481757Z ##[debug]SendX5C - False
2022-04-11T17:17:00.2490873Z ##[debug]LoginHint ? False
2022-04-11T17:17:00.2500357Z ##[debug]IsBrokerConfigured - False
2022-04-11T17:17:00.2509806Z ##[debug]HomeAccountId - False
2022-04-11T17:17:00.2519232Z ##[debug]CorrelationId - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792
2022-04-11T17:17:00.2539828Z ##[debug]
2022-04-11T17:17:00.2540941Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T17:17:00.2548706Z ##[debug]  
2022-04-11T17:17:00.2558967Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T17:17:00.2573300Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 17:17:00) - Expiration Time (04/11/2022 18:16:54 +00:00) - Extended Expiration Time (04/11/2022 18:16:54 +00:00)]
2022-04-11T17:17:00.2586995Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 17:17:00 - 04d0d92e-6fb1-4a20-a2ce-c78bbf8bd792] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 18:16:54 +00:00 ===
2022-04-11T17:17:00.2600054Z ##[debug]5:17:00 PM - Get-PowerBIAccessToken end processing.
2022-04-11T17:17:00.2614377Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=.pbix&nameConflict=Abort&skipReport=True
2022-04-11T17:17:00.5995004Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/imports?datasetDisplayName=.pbix&nameConflict=Abort&skipReport=True with -1-byte payload
2022-04-11T17:17:03.4857686Z Done processing Power BI Actions
2022-04-11T17:17:04.1183321Z ##[debug]Caught exception from task script.
2022-04-11T17:17:04.1210282Z ##[debug]Error record:
2022-04-11T17:17:04.1709787Z ##[debug]Invoke-API : The remote server returned an error: (400) Bad Request.
2022-04-11T17:17:04.1720899Z ##[debug]At D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:655 char:15
2022-04-11T17:17:04.1737546Z ##[debug]+ ...   $result = Invoke-API -Url $url -Method "Post" -Body $body -ContentT ...
2022-04-11T17:17:04.1747922Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-04-11T17:17:04.1749057Z ##[debug]    + CategoryInfo          : NotSpecified: (:) [Write-Error], WebException
2022-04-11T17:17:04.1759090Z ##[debug]    + FullyQualifiedErrorId : System.Net.WebException,Invoke-API
2022-04-11T17:17:04.1768498Z ##[debug] 
2022-04-11T17:17:04.1782739Z ##[debug]Script stack trace:
2022-04-11T17:17:04.1819066Z ##[debug]at Invoke-API, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 311
2022-04-11T17:17:04.1829781Z ##[debug]at Import-PowerBIFile, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 655
2022-04-11T17:17:04.1840304Z ##[debug]at Publish-PowerBIFileApi, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 862
2022-04-11T17:17:04.1845384Z ##[debug]at <ScriptBlock><Process>, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1: line 102
2022-04-11T17:17:04.1858420Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-11T17:17:04.1864107Z ##[debug]at <ScriptBlock>, <No file>: line 22
2022-04-11T17:17:04.1871332Z ##[debug]at <ScriptBlock>, <No file>: line 18
2022-04-11T17:17:04.1881931Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-11T17:17:04.1896824Z ##[debug]Exception:
2022-04-11T17:17:04.1931342Z ##[debug]System.Net.WebException: The remote server returned an error: (400) Bad Request.
2022-04-11T17:17:04.1941018Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
2022-04-11T17:17:04.1951135Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
2022-04-11T17:17:04.2160515Z ##[error]The remote server returned an error: (400) Bad Request.
2022-04-11T17:17:04.2174102Z ##[debug]Processed: ##vso[task.logissue type=error]The remote server returned an error: (400) Bad Request.
2022-04-11T17:17:04.2181983Z ##[debug]Processed: ##vso[task.complete result=Failed]
2022-04-11T17:17:04.6677075Z ##[section]Finishing: Power BI Action: Publish
lululorcan commented 2 years ago

I think the issue is caused by SkipReport: true

When I remove that variable, I am able to overwrite the report with name 'Today's Sales DEV.pbix'

When I remove that variable and run the pipeline with report named '.pbix' I get the below error:

[error]'datasetDisplayName' cannot be null.

logs below

2022-04-11T19:20:50.6000705Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish'
2022-04-11T19:20:50.6002617Z ##[debug]Evaluating: SucceededNode()
2022-04-11T19:20:50.6003093Z ##[debug]Evaluating SucceededNode:
2022-04-11T19:20:50.6004223Z ##[debug]=> True
2022-04-11T19:20:50.6004676Z ##[debug]Result: True
2022-04-11T19:20:50.6005091Z ##[section]Starting: Power BI Action: Publish
2022-04-11T19:20:50.6118351Z ==============================================================================
2022-04-11T19:20:50.6118753Z Task         : Power BI Actions
2022-04-11T19:20:50.6118974Z Description  : Release Task Power BI Actions
2022-04-11T19:20:50.6119179Z Version      : 5.4.31
2022-04-11T19:20:50.6119356Z Author       : Maik van der Gaag
2022-04-11T19:20:50.6119524Z Help         : 
2022-04-11T19:20:50.6119749Z ==============================================================================
2022-04-11T19:20:51.5460706Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2022-04-11T19:20:51.7090355Z Starting Power BI Actions extension
2022-04-11T19:20:51.7240460Z ##[debug]Entering D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1.
2022-04-11T19:20:51.7350269Z ### Required Module is needed. Importing now...
2022-04-11T19:20:51.7378267Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2022-04-11T19:20:51.7382986Z ##[debug]Loading 'TypesToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2022-04-11T19:20:51.7524034Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2022-04-11T19:20:51.7818888Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2022-04-11T19:20:51.7820159Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2022-04-11T19:20:51.7836425Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-11T19:20:51.7915107Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-11T19:20:51.7945498Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2022-04-11T19:20:51.7946785Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-11T19:20:51.7965936Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2022-04-11T19:20:51.7973118Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-11T19:20:51.7992543Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-11T19:20:51.8016491Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2022-04-11T19:20:51.8047248Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-11T19:20:51.8048383Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2022-04-11T19:20:51.8063680Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2022-04-11T19:20:51.8078868Z ##[debug]Importing alias 'Login-PowerBI'.
2022-04-11T19:20:51.8093717Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2022-04-11T19:20:51.8111308Z ##[debug]Importing alias 'Logout-PowerBI'.
2022-04-11T19:20:51.8126813Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2022-04-11T19:20:51.8141912Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2022-04-11T19:20:51.8145180Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2022-04-11T19:20:51.8232934Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2022-04-11T19:20:51.8284394Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2022-04-11T19:20:51.8439160Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2022-04-11T19:20:51.8447995Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2022-04-11T19:20:51.8540554Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-11T19:20:51.8593509Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2022-04-11T19:20:51.8614153Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-11T19:20:51.8635024Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2022-04-11T19:20:51.9573915Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-11T19:20:51.9591433Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2022-04-11T19:20:51.9610630Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2022-04-11T19:20:51.9627354Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-11T19:20:51.9630288Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2022-04-11T19:20:51.9644389Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-11T19:20:51.9674293Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2022-04-11T19:20:51.9688870Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-11T19:20:51.9703004Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2022-04-11T19:20:51.9717154Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2022-04-11T19:20:51.9732728Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2022-04-11T19:20:51.9759970Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2022-04-11T19:20:51.9761049Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2022-04-11T19:20:51.9767123Z ##[debug]Importing alias 'New-PowerBIGroup'.
2022-04-11T19:20:51.9793857Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2022-04-11T19:20:51.9795398Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2022-04-11T19:20:51.9807086Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2022-04-11T19:20:51.9894579Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2022-04-11T19:20:51.9920807Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2022-04-11T19:20:51.9945572Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2022-04-11T19:20:51.9985975Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2022-04-11T19:20:52.0013274Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2022-04-11T19:20:52.0032929Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2022-04-11T19:20:52.0048450Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2022-04-11T19:20:52.0063346Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2022-04-11T19:20:52.0079253Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2022-04-11T19:20:52.0093370Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2022-04-11T19:20:52.0095824Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2022-04-11T19:20:52.0108990Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2022-04-11T19:20:52.0137680Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2022-04-11T19:20:52.0152814Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2022-04-11T19:20:52.0167758Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2022-04-11T19:20:52.0182978Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2022-04-11T19:20:52.0197131Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2022-04-11T19:20:52.0211326Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2022-04-11T19:20:52.0216690Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2022-04-11T19:20:52.0240054Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2022-04-11T19:20:52.0246449Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2022-04-11T19:20:52.0260758Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2022-04-11T19:20:52.0288937Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2022-04-11T19:20:52.0318471Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2022-04-11T19:20:52.0374269Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2022-04-11T19:20:52.0393354Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2022-04-11T19:20:52.0642200Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2022-04-11T19:20:52.0666345Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2022-04-11T19:20:52.0698797Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2022-04-11T19:20:52.0731166Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2022-04-11T19:20:52.0746402Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2022-04-11T19:20:52.0760663Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2022-04-11T19:20:52.0772171Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-11T19:20:52.0788240Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2022-04-11T19:20:52.0798361Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2022-04-11T19:20:52.0827846Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2022-04-11T19:20:52.0828969Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2022-04-11T19:20:52.0843661Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2022-04-11T19:20:52.0847151Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2022-04-11T19:20:52.0860409Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2022-04-11T19:20:52.0900270Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2022-04-11T19:20:52.0901297Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2022-04-11T19:20:52.0915145Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2022-04-11T19:20:52.0930651Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2022-04-11T19:20:52.0958182Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2022-04-11T19:20:52.0959236Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2022-04-11T19:20:52.0969760Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-11T19:20:52.0994621Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2022-04-11T19:20:52.0996879Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2022-04-11T19:20:52.1004077Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2022-04-11T19:20:52.1017301Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2022-04-11T19:20:52.1043726Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2022-04-11T19:20:52.1059223Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2022-04-11T19:20:52.1073396Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2022-04-11T19:20:52.1081115Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2022-04-11T19:20:52.1096305Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2022-04-11T19:20:52.1151403Z ### Trying to import the incorporated module for PowerBI
2022-04-11T19:20:52.1785313Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1'.
2022-04-11T19:20:52.2996187Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-11T19:20:52.3009941Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-11T19:20:52.3031052Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2022-04-11T19:20:52.3052602Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-11T19:20:52.3053916Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2022-04-11T19:20:52.3057967Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2022-04-11T19:20:52.3072031Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2022-04-11T19:20:52.3082201Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2022-04-11T19:20:52.3106886Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2022-04-11T19:20:52.3119845Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2022-04-11T19:20:52.3132727Z ##[debug]Exporting function 'Invoke-API'.
2022-04-11T19:20:52.3139830Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2022-04-11T19:20:52.3157136Z ##[debug]Exporting function 'New-DatasetRefresh'.
2022-04-11T19:20:52.3163035Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2022-04-11T19:20:52.3182942Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2022-04-11T19:20:52.3191485Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2022-04-11T19:20:52.3217639Z ##[debug]Exporting function 'Get-PowerBIReport'.
2022-04-11T19:20:52.3218623Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2022-04-11T19:20:52.3224752Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2022-04-11T19:20:52.3236783Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2022-04-11T19:20:52.3253099Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2022-04-11T19:20:52.3284915Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2022-04-11T19:20:52.3285938Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2022-04-11T19:20:52.3298681Z ##[debug]Exporting function 'Import-PowerBIFile'.
2022-04-11T19:20:52.3312493Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2022-04-11T19:20:52.3325535Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2022-04-11T19:20:52.3339855Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2022-04-11T19:20:52.3353144Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2022-04-11T19:20:52.3366544Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2022-04-11T19:20:52.3369680Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2022-04-11T19:20:52.3381751Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2022-04-11T19:20:52.3406144Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2022-04-11T19:20:52.3419356Z ##[debug]Exporting function 'Set-Capacity'.
2022-04-11T19:20:52.3432775Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2022-04-11T19:20:52.3445601Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-11T19:20:52.3459801Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2022-04-11T19:20:52.3486957Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2022-04-11T19:20:52.3488014Z ##[debug]Exporting function 'Publish-TabularEditor'.
2022-04-11T19:20:52.3498074Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2022-04-11T19:20:52.3524180Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2022-04-11T19:20:52.3525193Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2022-04-11T19:20:52.3530301Z ##[debug]Importing function 'Get-PowerBICapacity'.
2022-04-11T19:20:52.3544272Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2022-04-11T19:20:52.3561475Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2022-04-11T19:20:52.3578610Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-11T19:20:52.3592094Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2022-04-11T19:20:52.3615416Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2022-04-11T19:20:52.3616489Z ##[debug]Importing function 'Get-PowerBIGateways'.
2022-04-11T19:20:52.3630291Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2022-04-11T19:20:52.3644562Z ##[debug]Importing function 'Get-PowerBiParameters'.
2022-04-11T19:20:52.3658477Z ##[debug]Importing function 'Get-PowerBIReport'.
2022-04-11T19:20:52.3685323Z ##[debug]Importing function 'Import-PowerBIFile'.
2022-04-11T19:20:52.3686424Z ##[debug]Importing function 'Invoke-API'.
2022-04-11T19:20:52.3687050Z ##[debug]Importing function 'New-DatasetRefresh'.
2022-04-11T19:20:52.3699629Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2022-04-11T19:20:52.3723772Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2022-04-11T19:20:52.3736731Z ##[debug]Importing function 'Publish-PowerBIFile'.
2022-04-11T19:20:52.3749602Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2022-04-11T19:20:52.3762915Z ##[debug]Importing function 'Publish-TabularEditor'.
2022-04-11T19:20:52.3787142Z ##[debug]Importing function 'Redo-PowerBIReport'.
2022-04-11T19:20:52.3788303Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-11T19:20:52.3800962Z ##[debug]Importing function 'Remove-PowerBIReport'.
2022-04-11T19:20:52.3815937Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2022-04-11T19:20:52.3829995Z ##[debug]Importing function 'Set-Capacity'.
2022-04-11T19:20:52.3831341Z ##[debug]Importing function 'Set-DatasetOwnership'.
2022-04-11T19:20:52.3841822Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2022-04-11T19:20:52.3865044Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-11T19:20:52.3878716Z ##[debug]Importing function 'Set-RefreshSchedule'.
2022-04-11T19:20:52.3891567Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2022-04-11T19:20:52.3904358Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2022-04-11T19:20:52.3917332Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2022-04-11T19:20:52.3930110Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2022-04-11T19:20:52.3942564Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-11T19:20:52.3955358Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2022-04-11T19:20:52.3968355Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2022-04-11T19:20:52.3978072Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2022-04-11T19:20:52.4257707Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '46b0eb2e-0fb1-499b-93f2-30d15caf9d66'
2022-04-11T19:20:52.4332549Z ##[debug]ENDPOINT_URL_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: 'https://api.powerbi.com/v1.0/myorg'
2022-04-11T19:20:52.4352520Z ##[debug]ENDPOINT_AUTH_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '********'
2022-04-11T19:20:52.4372053Z ##[debug]ENDPOINT_DATA_46b0eb2e-0fb1-499b-93f2-30d15caf9d66: '{"OrganizationType":"Public"}'
2022-04-11T19:20:52.5043218Z ##[debug]{
2022-04-11T19:20:52.5053190Z ##[debug]    "Url":  "https://api.powerbi.com/v1.0/myorg",
2022-04-11T19:20:52.5063059Z ##[debug]    "Data":  {
2022-04-11T19:20:52.5072557Z ##[debug]                 "OrganizationType":  "Public"
2022-04-11T19:20:52.5083963Z ##[debug]             },
2022-04-11T19:20:52.5095746Z ##[debug]    "Auth":  {
2022-04-11T19:20:52.5103222Z ##[debug]                 "parameters":  {
2022-04-11T19:20:52.5113729Z ##[debug]                                    "TenantId":  "59762c14-55e8-4b58-806e-f6cc47d75b19",
2022-04-11T19:20:52.5119546Z ##[debug]                                    "ClientId":  "***",
2022-04-11T19:20:52.5128932Z ##[debug]                                    "ClientSecret":  ***,
2022-04-11T19:20:52.5134908Z ##[debug]                                    "ClientCertificate":  ""
2022-04-11T19:20:52.5143811Z ##[debug]                                },
2022-04-11T19:20:52.5160231Z ##[debug]                 "scheme":  "None"
2022-04-11T19:20:52.5230467Z ##[debug]             }
2022-04-11T19:20:52.5253854Z ##[debug]}
2022-04-11T19:20:52.6859605Z ##[debug]7:20:52 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2022-04-11T19:20:52.6905349Z ##[debug]7:20:52 PM - Cmdlet version: 1.2.1077.0
2022-04-11T19:20:52.7161081Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/59762c14-55e8-4b58-806e-f6cc47d75b19
2022-04-11T19:20:52.8830492Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52] Found 0 cache accounts and 0 broker accounts
2022-04-11T19:20:52.8867677Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(8eb9b802-9f25-454f-96ed-a4bcee73a3df)
2022-04-11T19:20:52.8881614Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] === AcquireTokenForClientParameters ===
2022-04-11T19:20:52.8884896Z ##[debug]SendX5C: False
2022-04-11T19:20:52.8901299Z ##[debug]WithAzureRegion: False
2022-04-11T19:20:52.8911856Z ##[debug]RegionToUse: 
2022-04-11T19:20:52.8924486Z ##[debug]ForceRefresh: False
2022-04-11T19:20:52.8960877Z ##[debug]
2022-04-11T19:20:52.9051347Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] 
2022-04-11T19:20:52.9056785Z ##[debug]=== Request Data ===
2022-04-11T19:20:52.9084632Z ##[debug]Authority Provided? - True
2022-04-11T19:20:52.9085629Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T19:20:52.9095885Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T19:20:52.9105928Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T19:20:52.9115342Z ##[debug]IsConfidentialClient - True
2022-04-11T19:20:52.9121173Z ##[debug]SendX5C - False
2022-04-11T19:20:52.9140846Z ##[debug]LoginHint ? False
2022-04-11T19:20:52.9141836Z ##[debug]IsBrokerConfigured - False
2022-04-11T19:20:52.9152183Z ##[debug]HomeAccountId - False
2022-04-11T19:20:52.9162201Z ##[debug]CorrelationId - 8eb9b802-9f25-454f-96ed-a4bcee73a3df
2022-04-11T19:20:52.9169792Z ##[debug]
2022-04-11T19:20:52.9193918Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T19:20:52.9206572Z ##[debug]  
2022-04-11T19:20:52.9212297Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T19:20:52.9590622Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:52 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Fetching instance discovery from the network from host login.microsoftonline.com. 
2022-04-11T19:20:53.4995595Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Resolving authority endpoints... Already resolved? - FALSE
2022-04-11T19:20:53.5010294Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] ScopeSet was missing from the token response, so using developer provided scopes in the result. 
2022-04-11T19:20:53.5024825Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Checking client info returned from the server..
2022-04-11T19:20:53.5038907Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Saving Token Response to cache..
2022-04-11T19:20:53.5052425Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] ID Token not present in response. 
2022-04-11T19:20:53.5086840Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Saving AT in cache and removing overlapping ATs...
2022-04-11T19:20:53.5088583Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2022-04-11T19:20:53.5103008Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] Intersecting scope entries count - 0
2022-04-11T19:20:53.5107019Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 8eb9b802-9f25-454f-96ed-a4bcee73a3df] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 20:20:52 +00:00 ===
2022-04-11T19:20:53.5123935Z ##[debug]7:20:53 PM - Connect-PowerBIServiceAccount end processing.
2022-04-11T19:20:53.5142785Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s\**.pbix'
2022-04-11T19:20:53.5160797Z ##[debug]INPUT_WORKSPACENAME: 'PBI - DevOPS - DEV/QA'
2022-04-11T19:20:53.5178712Z ##[debug]INPUT_OVERWRITE: 'true'
2022-04-11T19:20:53.5209976Z ##[debug] Converted to bool: True
2022-04-11T19:20:53.5227350Z ##[debug]INPUT_CREATE: 'true'
2022-04-11T19:20:53.5240639Z ##[debug] Converted to bool: True
2022-04-11T19:20:53.5258515Z ##[debug]INPUT_ACTION: 'Publish'
2022-04-11T19:20:53.5275694Z ##[debug]INPUT_DATASETNAME (empty)
2022-04-11T19:20:53.5313491Z ##[debug]INPUT_OLDURL (empty)
2022-04-11T19:20:53.5331291Z ##[debug]INPUT_NEWURL (empty)
2022-04-11T19:20:53.5349049Z ##[debug]INPUT_OLDSERVER (empty)
2022-04-11T19:20:53.5366602Z ##[debug]INPUT_NEWSERVER (empty)
2022-04-11T19:20:53.5383634Z ##[debug]INPUT_OLDDATABASE (empty)
2022-04-11T19:20:53.5400787Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2022-04-11T19:20:53.5417635Z ##[debug]INPUT_NEWDATABASE (empty)
2022-04-11T19:20:53.5435251Z ##[debug]INPUT_PERMISSION (empty)
2022-04-11T19:20:53.5452097Z ##[debug]INPUT_USERS (empty)
2022-04-11T19:20:53.5470145Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2022-04-11T19:20:53.5487302Z ##[debug]INPUT_UPDATEALL: 'false'
2022-04-11T19:20:53.5500739Z ##[debug] Converted to bool: False
2022-04-11T19:20:53.5517959Z ##[debug]INPUT_SKIPREPORT: 'false'
2022-04-11T19:20:53.5531663Z ##[debug] Converted to bool: False
2022-04-11T19:20:53.5548902Z ##[debug]INPUT_INDIVIDUAL (empty)
2022-04-11T19:20:53.5566265Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2022-04-11T19:20:53.5595704Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2022-04-11T19:20:53.5614149Z ##[debug]INPUT_PARAMETERINPUT (empty)
2022-04-11T19:20:53.5632876Z ##[debug]INPUT_GATEWAYNAME (empty)
2022-04-11T19:20:53.5650556Z ##[debug]INPUT_REPORTNAME (empty)
2022-04-11T19:20:53.5668461Z ##[debug]INPUT_CAPACITYNAME (empty)
2022-04-11T19:20:53.5685190Z ##[debug]INPUT_USERNAME (empty)
2022-04-11T19:20:53.5895448Z ##[debug]INPUT_PASSWORD (empty)
2022-04-11T19:20:53.5979494Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2022-04-11T19:20:53.6504756Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2022-04-11T19:20:53.6523731Z ##[debug] Converted to bool: False
2022-04-11T19:20:53.6541016Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2022-04-11T19:20:53.6569022Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2022-04-11T19:20:53.6594463Z ##[debug]WorkspaceName         : PBI - DevOPS - DEV/QA
2022-04-11T19:20:53.6595492Z ##[debug]Create                : True
2022-04-11T19:20:53.6609010Z ##[debug]File patern             : D:\a\1\s\**.pbix
2022-04-11T19:20:53.6743965Z ##[debug]Remove report           : False
2022-04-11T19:20:53.6855433Z Getting Power BI Workspace properties; PBI - DevOPS - DEV/QA
2022-04-11T19:20:53.6914472Z ##[debug]7:20:53 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-11T19:20:53.6979311Z ##[debug]7:20:53 PM - Cmdlet version: 1.2.1077.0
2022-04-11T19:20:53.7264103Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53] Found 0 cache accounts and 0 broker accounts
2022-04-11T19:20:53.7281165Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(698c3b39-7175-4c64-9fc7-7ca991545f64)
2022-04-11T19:20:53.7295306Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] === AcquireTokenForClientParameters ===
2022-04-11T19:20:53.7305011Z ##[debug]SendX5C: False
2022-04-11T19:20:53.7315176Z ##[debug]WithAzureRegion: False
2022-04-11T19:20:53.7324864Z ##[debug]RegionToUse: 
2022-04-11T19:20:53.7334875Z ##[debug]ForceRefresh: False
2022-04-11T19:20:53.7344883Z ##[debug]
2022-04-11T19:20:53.7360290Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] 
2022-04-11T19:20:53.7370131Z ##[debug]=== Request Data ===
2022-04-11T19:20:53.7380081Z ##[debug]Authority Provided? - True
2022-04-11T19:20:53.7390125Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T19:20:53.7399653Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T19:20:53.7409342Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T19:20:53.7418833Z ##[debug]IsConfidentialClient - True
2022-04-11T19:20:53.7428532Z ##[debug]SendX5C - False
2022-04-11T19:20:53.7437818Z ##[debug]LoginHint ? False
2022-04-11T19:20:53.7449298Z ##[debug]IsBrokerConfigured - False
2022-04-11T19:20:53.7458693Z ##[debug]HomeAccountId - False
2022-04-11T19:20:53.7468375Z ##[debug]CorrelationId - 698c3b39-7175-4c64-9fc7-7ca991545f64
2022-04-11T19:20:53.7477903Z ##[debug]
2022-04-11T19:20:53.7492086Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T19:20:53.7501305Z ##[debug]  
2022-04-11T19:20:53.7510899Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T19:20:53.7562686Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 19:20:53) - Expiration Time (04/11/2022 20:20:52 +00:00) - Extended Expiration Time (04/11/2022 20:20:52 +00:00)]
2022-04-11T19:20:53.7586084Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:53 - 698c3b39-7175-4c64-9fc7-7ca991545f64] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 20:20:52 +00:00 ===
2022-04-11T19:20:54.3674432Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi - devops - dev/qa'&$top=100
2022-04-11T19:20:54.3688516Z ##[debug]Status Code: OK (200)
2022-04-11T19:20:54.3703452Z ##[debug]7:20:54 PM - Get-PowerBIWorkspace end processing.
2022-04-11T19:20:54.3766127Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]ba8159af-9cf0-4f44-ba1a-3308e266b550
2022-04-11T19:20:54.3781150Z ##[debug]7:20:54 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-11T19:20:54.3795204Z ##[debug]7:20:54 PM - Cmdlet version: 1.2.1077.0
2022-04-11T19:20:54.3810194Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54] Found 0 cache accounts and 0 broker accounts
2022-04-11T19:20:54.3824236Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(e4606752-29bf-47ba-80bb-340b58030dc6)
2022-04-11T19:20:54.3838327Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] === AcquireTokenForClientParameters ===
2022-04-11T19:20:54.3847993Z ##[debug]SendX5C: False
2022-04-11T19:20:54.3858008Z ##[debug]WithAzureRegion: False
2022-04-11T19:20:54.3867588Z ##[debug]RegionToUse: 
2022-04-11T19:20:54.3877376Z ##[debug]ForceRefresh: False
2022-04-11T19:20:54.3886760Z ##[debug]
2022-04-11T19:20:54.3901920Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] 
2022-04-11T19:20:54.3911721Z ##[debug]=== Request Data ===
2022-04-11T19:20:54.3921676Z ##[debug]Authority Provided? - True
2022-04-11T19:20:54.3932058Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T19:20:54.3942535Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T19:20:54.3952727Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T19:20:54.3962272Z ##[debug]IsConfidentialClient - True
2022-04-11T19:20:54.3972626Z ##[debug]SendX5C - False
2022-04-11T19:20:54.3982015Z ##[debug]LoginHint ? False
2022-04-11T19:20:54.3992034Z ##[debug]IsBrokerConfigured - False
2022-04-11T19:20:54.4001499Z ##[debug]HomeAccountId - False
2022-04-11T19:20:54.4011302Z ##[debug]CorrelationId - e4606752-29bf-47ba-80bb-340b58030dc6
2022-04-11T19:20:54.4020679Z ##[debug]
2022-04-11T19:20:54.4034906Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T19:20:54.4044164Z ##[debug]  
2022-04-11T19:20:54.4054320Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T19:20:54.4068774Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 19:20:54) - Expiration Time (04/11/2022 20:20:52 +00:00) - Extended Expiration Time (04/11/2022 20:20:52 +00:00)]
2022-04-11T19:20:54.4083384Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - e4606752-29bf-47ba-80bb-340b58030dc6] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 20:20:52 +00:00 ===
2022-04-11T19:20:54.6183023Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi - devops - dev/qa'&$top=100
2022-04-11T19:20:54.6198665Z ##[debug]Status Code: OK (200)
2022-04-11T19:20:54.6213694Z ##[debug]7:20:54 PM - Get-PowerBIWorkspace end processing.
2022-04-11T19:20:54.6287123Z Trying to publish PowerBI File: D:\a\1\s\.pbix
2022-04-11T19:20:54.6326528Z Checking for existing Reports with the name: 
2022-04-11T19:20:54.6385920Z ##[debug]7:20:54 PM - New-PowerBIReport begin processing with ParameterSet Workspace.
2022-04-11T19:20:54.6400033Z ##[debug]7:20:54 PM - Cmdlet version: 1.2.1077.0
2022-04-11T19:20:54.6425119Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54] Found 0 cache accounts and 0 broker accounts
2022-04-11T19:20:54.6439372Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(b1343412-ad8a-4b1e-a93f-e88f281aeada)
2022-04-11T19:20:54.6453261Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] === AcquireTokenForClientParameters ===
2022-04-11T19:20:54.6463011Z ##[debug]SendX5C: False
2022-04-11T19:20:54.6472903Z ##[debug]WithAzureRegion: False
2022-04-11T19:20:54.6482848Z ##[debug]RegionToUse: 
2022-04-11T19:20:54.6492645Z ##[debug]ForceRefresh: False
2022-04-11T19:20:54.6502704Z ##[debug]
2022-04-11T19:20:54.6517277Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] 
2022-04-11T19:20:54.6526967Z ##[debug]=== Request Data ===
2022-04-11T19:20:54.6536807Z ##[debug]Authority Provided? - True
2022-04-11T19:20:54.6546657Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-11T19:20:54.6556293Z ##[debug]Extra Query Params Keys (space separated) - 
2022-04-11T19:20:54.6565672Z ##[debug]ApiId - AcquireTokenForClient
2022-04-11T19:20:54.6575568Z ##[debug]IsConfidentialClient - True
2022-04-11T19:20:54.6585035Z ##[debug]SendX5C - False
2022-04-11T19:20:54.6594805Z ##[debug]LoginHint ? False
2022-04-11T19:20:54.6604661Z ##[debug]IsBrokerConfigured - False
2022-04-11T19:20:54.6614455Z ##[debug]HomeAccountId - False
2022-04-11T19:20:54.6697624Z ##[debug]CorrelationId - b1343412-ad8a-4b1e-a93f-e88f281aeada
2022-04-11T19:20:54.6707155Z ##[debug]
2022-04-11T19:20:54.6722573Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] === Token Acquisition (ClientCredentialRequest) started:
2022-04-11T19:20:54.6731763Z ##[debug]  
2022-04-11T19:20:54.6742002Z ##[debug]  Authority Host: login.microsoftonline.com
2022-04-11T19:20:54.6757121Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] Access token is not expired. Returning the found cache entry. [Current time (04/11/2022 19:20:54) - Expiration Time (04/11/2022 20:20:52 +00:00) - Extended Expiration Time (04/11/2022 20:20:52 +00:00)]
2022-04-11T19:20:54.6770946Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [04/11/2022 19:20:54 - b1343412-ad8a-4b1e-a93f-e88f281aeada] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/11/2022 20:20:52 +00:00 ===
2022-04-11T19:20:54.8454191Z Done processing Power BI Actions
2022-04-11T19:20:54.8987040Z ##[debug]Caught exception from task script.
2022-04-11T19:20:54.9014127Z ##[debug]Error record:
2022-04-11T19:20:54.9542994Z ##[debug]New-PowerBIReport : 'datasetDisplayName' cannot be null.
2022-04-11T19:20:54.9554147Z ##[debug]At D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:797 char:27
2022-04-11T19:20:54.9564122Z ##[debug]+ ...   $report = New-PowerBIReport -Path $filePath -Name $fileToPublish -W ...
2022-04-11T19:20:54.9574458Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-04-11T19:20:54.9584753Z ##[debug]    + CategoryInfo          : WriteError: (Microsoft.Power...ewPowerBIReport:NewPowerBIReport) [New-PowerBIReport], Va    lidationException
2022-04-11T19:20:54.9594700Z ##[debug]    + FullyQualifiedErrorId : 'datasetDisplayName' cannot be null.,Microsoft.PowerBI.Commands.Reports.NewPowerBIReport
2022-04-11T19:20:54.9604413Z ##[debug] 
2022-04-11T19:20:54.9619201Z ##[debug]Script stack trace:
2022-04-11T19:20:54.9648410Z ##[debug]at Publish-PowerBIFile, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 797
2022-04-11T19:20:54.9658351Z ##[debug]at <ScriptBlock><Process>, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1: line 104
2022-04-11T19:20:54.9669874Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-11T19:20:54.9678985Z ##[debug]at <ScriptBlock>, <No file>: line 22
2022-04-11T19:20:54.9689336Z ##[debug]at <ScriptBlock>, <No file>: line 18
2022-04-11T19:20:54.9699047Z ##[debug]at <ScriptBlock>, <No file>: line 1
2022-04-11T19:20:54.9713850Z ##[debug]Exception:
2022-04-11T19:20:54.9768562Z ##[debug]Microsoft.Rest.ValidationException: 'datasetDisplayName' cannot be null.
2022-04-11T19:20:54.9778292Z ##[debug]   at Microsoft.PowerBI.Api.V2.Imports.<PostImportFileWithHttpMessage>d__7.MoveNext()
2022-04-11T19:20:54.9788258Z ##[debug]--- End of stack trace from previous location where exception was thrown ---
2022-04-11T19:20:54.9797976Z ##[debug]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
2022-04-11T19:20:54.9808275Z ##[debug]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
2022-04-11T19:20:54.9817417Z ##[debug]   at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport)
2022-04-11T19:20:54.9827436Z ##[debug]   at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict)
2022-04-11T19:20:54.9837342Z ##[debug]   at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout)
2022-04-11T19:20:54.9846993Z ##[debug]   at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet()
2022-04-11T19:20:54.9856704Z ##[debug]   at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord()
2022-04-11T19:20:55.0087586Z ##[error]'datasetDisplayName' cannot be null.
2022-04-11T19:20:55.0097289Z ##[debug]Processed: ##vso[task.logissue type=error]'datasetDisplayName' cannot be null.
2022-04-11T19:20:55.0104863Z ##[debug]Processed: ##vso[task.complete result=Failed]
2022-04-11T19:20:55.0361800Z ##[section]Finishing: Power BI Action: Publish
maikvandergaag commented 2 years ago

Could you try calling it test.pbix

lululorcan commented 2 years ago

Same error.

Below some findings with overwrite: true & skipreport: true: Dataset and report exist in workspace -> Passes Dataset only exists in workspace -> Fail 400 error

Is the bug because the following API call returns nothing as there is only a dataset and not a report in the workspace? GET https://api.powerbi.com/v1.0/myorg/groups/ba8159af-9cf0-4f44-ba1a-3308e266b550/reports

maikvandergaag commented 2 years ago

Yes I think that is the case

maikvandergaag commented 2 years ago

Will try to resolve this in the upcoming weeks

harshagarwal91 commented 2 years ago

+1 on this issue, I have started facing this issue all of a sudden and deployment is not working properly.

maikvandergaag commented 2 years ago

Does it work when you set SkipReport to false? Do you have that set to true for a specific reason?