maikvandergaag / msft-extensions

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

Unable to publish pbix file (no error message but nothing happens in workspace) #436

Closed 99Wasdqwop closed 1 year ago

99Wasdqwop commented 1 year ago

Hello,

I'm trying to upload a PBIX file to a workspace through a devops release pipeline, and then refresh the dataset. My workflow is: edit a pbix file in PBI desktop -> check it in to source control -> publish an artifact for a devops release pipeline -> publish the pbix file with a release pipeline and the help of this extension

The logging of the extension says it's finished succesfully, but nothing happens in my source. It does not overwrite an existing dataset, and if I change the name to a dataset that doesn't yet exist in my workspace, it doesn't add that either. In short; nothing seems to happen.

I've manged to narrow the issue down to the extention itself (I believe). I manipulated the .pbix file and managed to track these changes all the way to the point where the extension tries to publish it. After it "succesfully" published the file, nothing has happened in my workspace. No new reports added or existing reports updated, no new dataset added or a existing dataset updated.

Refreshing the existing dataset does work. I've also verified that the service principal has all the necessary rights but I could have made a mistake there of course. The sp is an admin and Ive set the toggle in the portal settings. In any case, I don't get an error and refreshing a dataset works just fine.

One more thing - the extension page says it has 2 features that do not exist as "Actions" in my extension (i use version 5.4.39). Those features are : Upload / Import Power BI dashboard (pbix file). Upload / Import Power BI dashboard and skip report (pbix file). The first one is exactly what I want to do. I made the assumption that I have to use the action "Upload PowerBI Report". By the way, I tried out skipping report/not skipping report and overwriting/not overwriting datasets. Nothing happened every time.

Thank you for your help!

This is the output from the Publish task (full debug log below)

2022-08-31T13:29:27.5573509Z ##[section]Starting: Power BI Action: Publish 2022-08-31T13:29:27.5702479Z ============================================================================== 2022-08-31T13:29:27.5702769Z Task : Power BI Actions 2022-08-31T13:29:27.5702967Z Description : Release Task Power BI Actions 2022-08-31T13:29:27.5703141Z Version : 5.4.39 2022-08-31T13:29:27.5703318Z Author : Maik van der Gaag 2022-08-31T13:29:27.5704141Z Help : 2022-08-31T13:29:27.5704350Z ============================================================================== 2022-08-31T13:29:29.0025152Z Starting Power BI Actions extension 2022-08-31T13:29:29.0263643Z ### Required Module is needed. Importing now... 2022-08-31T13:29:29.3099798Z ### Trying to import the incorporated module for PowerBI 2022-08-31T13:29:30.9116984Z Getting Power BI Workspace properties; [MyWorkspace] 2022-08-31T13:29:31.9682235Z Done processing Power BI Actions 2022-08-31T13:29:31.9684577Z Done running Power BI Actions extension. 2022-08-31T13:29:32.0059038Z ##[section]Finishing: Power BI Action: Publish

Agent information: 2022-08-31T13:29:11.0691431Z Agent name: 'Hosted Agent' 2022-08-31T13:29:11.0692115Z Current agent version: '2.209.0' 2022-08-31T13:29:11.0744532Z ##[group]Operating System 2022-08-31T13:29:11.0744847Z Microsoft Windows Server 2022 2022-08-31T13:29:11.0745179Z Datacenter 2022-08-31T13:29:11.0745321Z ##[endgroup] 2022-08-31T13:29:11.0745480Z ##[group]Runner Image 2022-08-31T13:29:11.0745656Z Image: windows-2022 2022-08-31T13:29:11.0745828Z Version: 20220828.1

Full debug log: 2022-08-31T13:46:20.1588120Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish' 2022-08-31T13:46:20.1590026Z ##[debug]Evaluating: succeeded() 2022-08-31T13:46:20.1590528Z ##[debug]Evaluating succeeded: 2022-08-31T13:46:20.1591983Z ##[debug]=> True 2022-08-31T13:46:20.1592453Z ##[debug]Result: True 2022-08-31T13:46:20.1592839Z ##[section]Starting: Power BI Action: Publish 2022-08-31T13:46:20.1727830Z ============================================================================== 2022-08-31T13:46:20.1728151Z Task : Power BI Actions 2022-08-31T13:46:20.1728935Z Description : Release Task Power BI Actions 2022-08-31T13:46:20.1729125Z Version : 5.4.39 2022-08-31T13:46:20.1729306Z Author : Maik van der Gaag 2022-08-31T13:46:20.1730260Z Help : 2022-08-31T13:46:20.1730480Z ============================================================================== 2022-08-31T13:46:21.1001128Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2022-08-31T13:46:21.2410149Z Starting Power BI Actions extension 2022-08-31T13:46:21.2532952Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-08-31T13:46:21.2627610Z ### Required Module is needed. Importing now... 2022-08-31T13:46:21.2680369Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2022-08-31T13:46:21.2757832Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2022-08-31T13:46:21.2791743Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2022-08-31T13:46:21.3247532Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2022-08-31T13:46:21.3289172Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2022-08-31T13:46:21.3426957Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2022-08-31T13:46:21.3453072Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-08-31T13:46:21.3475856Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2022-08-31T13:46:21.3526031Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2022-08-31T13:46:21.3532796Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2022-08-31T13:46:21.3583318Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2022-08-31T13:46:21.3607983Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-08-31T13:46:21.3630017Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2022-08-31T13:46:21.3680170Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2022-08-31T13:46:21.3702746Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2022-08-31T13:46:21.3724818Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2022-08-31T13:46:21.3747111Z ##[debug]Importing alias 'Login-PowerBI'. 2022-08-31T13:46:21.3770300Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2022-08-31T13:46:21.3793745Z ##[debug]Importing alias 'Logout-PowerBI'. 2022-08-31T13:46:21.3813431Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2022-08-31T13:46:21.3838645Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2022-08-31T13:46:21.3888224Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2022-08-31T13:46:21.3932923Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2022-08-31T13:46:21.4005858Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2022-08-31T13:46:21.4224758Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2022-08-31T13:46:21.4258283Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2022-08-31T13:46:21.4349053Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2022-08-31T13:46:21.4372534Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2022-08-31T13:46:21.4401147Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-08-31T13:46:21.4423219Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2022-08-31T13:46:21.5554313Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-08-31T13:46:21.5556368Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2022-08-31T13:46:21.5559377Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2022-08-31T13:46:21.5560967Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2022-08-31T13:46:21.5562278Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2022-08-31T13:46:21.5687205Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-08-31T13:46:21.5688491Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2022-08-31T13:46:21.5689532Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-08-31T13:46:21.5690498Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2022-08-31T13:46:21.5691475Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2022-08-31T13:46:21.5692608Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2022-08-31T13:46:21.5694934Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2022-08-31T13:46:21.5695905Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2022-08-31T13:46:21.5697643Z ##[debug]Importing alias 'New-PowerBIGroup'. 2022-08-31T13:46:21.5699434Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2022-08-31T13:46:21.5700462Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2022-08-31T13:46:21.5701391Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2022-08-31T13:46:21.5748851Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2022-08-31T13:46:21.5810332Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2022-08-31T13:46:21.5901970Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2022-08-31T13:46:21.5975963Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2022-08-31T13:46:21.6003791Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2022-08-31T13:46:21.6024967Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2022-08-31T13:46:21.6063562Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2022-08-31T13:46:21.6091287Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2022-08-31T13:46:21.6113438Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2022-08-31T13:46:21.6133675Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2022-08-31T13:46:21.6155415Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2022-08-31T13:46:21.6180989Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2022-08-31T13:46:21.6203422Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2022-08-31T13:46:21.6234642Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2022-08-31T13:46:21.6250907Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2022-08-31T13:46:21.6278877Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2022-08-31T13:46:21.6297236Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2022-08-31T13:46:21.6340394Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2022-08-31T13:46:21.6359682Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2022-08-31T13:46:21.6404576Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2022-08-31T13:46:21.6429733Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2022-08-31T13:46:21.6449132Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2022-08-31T13:46:21.6469663Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2022-08-31T13:46:21.6493698Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2022-08-31T13:46:21.6548614Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2022-08-31T13:46:21.6627038Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2022-08-31T13:46:21.6905410Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2022-08-31T13:46:21.6938773Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2022-08-31T13:46:21.7009811Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2022-08-31T13:46:21.7033771Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2022-08-31T13:46:21.7057761Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2022-08-31T13:46:21.7079022Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2022-08-31T13:46:21.7098036Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2022-08-31T13:46:21.7119204Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2022-08-31T13:46:21.7142705Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2022-08-31T13:46:21.7164157Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2022-08-31T13:46:21.7180602Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2022-08-31T13:46:21.7201168Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2022-08-31T13:46:21.7219879Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2022-08-31T13:46:21.7245300Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2022-08-31T13:46:21.7260426Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2022-08-31T13:46:21.7283629Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2022-08-31T13:46:21.7352444Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2022-08-31T13:46:21.8318761Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2022-08-31T13:46:21.8341733Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2022-08-31T13:46:21.8366800Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2022-08-31T13:46:21.8394155Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2022-08-31T13:46:21.8418029Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2022-08-31T13:46:21.8498438Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2022-08-31T13:46:21.8521640Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2022-08-31T13:46:21.8544216Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2022-08-31T13:46:21.8590074Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2022-08-31T13:46:21.8608402Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2022-08-31T13:46:21.8627501Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2022-08-31T13:46:21.8668330Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2022-08-31T13:46:21.8688121Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2022-08-31T13:46:21.8706107Z ### Trying to import the incorporated module for PowerBI 2022-08-31T13:46:21.8741589Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'. 2022-08-31T13:46:21.9181275Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-08-31T13:46:21.9210791Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-08-31T13:46:21.9222085Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2022-08-31T13:46:21.9242621Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-08-31T13:46:21.9263426Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2022-08-31T13:46:21.9314213Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2022-08-31T13:46:21.9364416Z ##[debug]Exporting function 'Set-DatasetOwnersXXX'. 2022-08-31T13:46:21.9385133Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnersXXX'. 2022-08-31T13:46:21.9406214Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2022-08-31T13:46:21.9425394Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2022-08-31T13:46:21.9444636Z ##[debug]Exporting function 'Invoke-API'. 2022-08-31T13:46:21.9465872Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2022-08-31T13:46:21.9515180Z ##[debug]Exporting function 'New-DatasetRefresh'. 2022-08-31T13:46:21.9535817Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2022-08-31T13:46:21.9554849Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2022-08-31T13:46:21.9579348Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2022-08-31T13:46:21.9598424Z ##[debug]Exporting function 'Get-PowerBIReport'. 2022-08-31T13:46:21.9633662Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2022-08-31T13:46:21.9692880Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2022-08-31T13:46:21.9716406Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2022-08-31T13:46:21.9773437Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2022-08-31T13:46:21.9796369Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2022-08-31T13:46:21.9847725Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2022-08-31T13:46:21.9896084Z ##[debug]Exporting function 'Import-PowerBIFile'. 2022-08-31T13:46:21.9916720Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2022-08-31T13:46:21.9937068Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2022-08-31T13:46:21.9956816Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2022-08-31T13:46:22.0002076Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2022-08-31T13:46:22.0021714Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2022-08-31T13:46:22.0041858Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2022-08-31T13:46:22.0087351Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2022-08-31T13:46:22.0189089Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2022-08-31T13:46:22.0189935Z ##[debug]Exporting function 'Set-Capacity'. 2022-08-31T13:46:22.0203911Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2022-08-31T13:46:22.0225568Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2022-08-31T13:46:22.0243803Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2022-08-31T13:46:22.0336678Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2022-08-31T13:46:22.0389160Z ##[debug]Exporting function 'Publish-TabularEditor'. 2022-08-31T13:46:22.0413309Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2022-08-31T13:46:22.0435958Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2022-08-31T13:46:22.0502386Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2022-08-31T13:46:22.0562073Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2022-08-31T13:46:22.0583024Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2022-08-31T13:46:22.0630698Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2022-08-31T13:46:22.0650940Z ##[debug]Importing function 'Get-PowerBICapacity'. 2022-08-31T13:46:22.0671885Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2022-08-31T13:46:22.0698640Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2022-08-31T13:46:22.0740698Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-08-31T13:46:22.0791358Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2022-08-31T13:46:22.0815979Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2022-08-31T13:46:22.0837930Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2022-08-31T13:46:22.0878243Z ##[debug]Importing function 'Get-PowerBIGateways'. 2022-08-31T13:46:22.0898584Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2022-08-31T13:46:22.0918651Z ##[debug]Importing function 'Get-PowerBiParameters'. 2022-08-31T13:46:22.0989805Z ##[debug]Importing function 'Get-PowerBIReport'. 2022-08-31T13:46:22.0998595Z ##[debug]Importing function 'Import-PowerBIFile'. 2022-08-31T13:46:22.1019719Z ##[debug]Importing function 'Invoke-API'. 2022-08-31T13:46:22.1105063Z ##[debug]Importing function 'New-DatasetRefresh'. 2022-08-31T13:46:22.1125366Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2022-08-31T13:46:22.1144663Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2022-08-31T13:46:22.1176232Z ##[debug]Importing function 'Publish-PowerBIFile'. 2022-08-31T13:46:22.1200351Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2022-08-31T13:46:22.1224467Z ##[debug]Importing function 'Publish-TabularEditor'. 2022-08-31T13:46:22.1252826Z ##[debug]Importing function 'Redo-PowerBIReport'. 2022-08-31T13:46:22.1272186Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2022-08-31T13:46:22.1320988Z ##[debug]Importing function 'Remove-PowerBIReport'. 2022-08-31T13:46:22.1343416Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2022-08-31T13:46:22.1383012Z ##[debug]Importing function 'Set-Capacity'. 2022-08-31T13:46:22.1404612Z ##[debug]Importing function 'Set-DatasetOwnersXXX'. 2022-08-31T13:46:22.1424481Z ##[debug]Importing function 'Set-PowerBIDataSetOwnersXXX'. 2022-08-31T13:46:22.1467478Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-08-31T13:46:22.1487465Z ##[debug]Importing function 'Set-RefreshSchedule'. 2022-08-31T13:46:22.1513021Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2022-08-31T13:46:22.1533458Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2022-08-31T13:46:22.1552066Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2022-08-31T13:46:22.1574703Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2022-08-31T13:46:22.1602466Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-08-31T13:46:22.1622009Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2022-08-31T13:46:22.1647786Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2022-08-31T13:46:22.1699437Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2022-08-31T13:46:22.2095792Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '9cf83ac7-2732-4f09-8cde-a98481e56b9e' 2022-08-31T13:46:22.2223229Z ##[debug]ENDPOINT_URL_9cf83ac7-2732-4f09-8cde-a98481e56b9e: 'https://api.powerbi.com/v1.0/myorg' 2022-08-31T13:46:22.2307755Z ##[debug]ENDPOINT_AUTH_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '****' 2022-08-31T13:46:22.2308971Z ##[debug]ENDPOINT_DATA_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '{"OrganizationType":"Public"}' 2022-08-31T13:46:22.2561993Z ##[debug]{ 2022-08-31T13:46:22.2580762Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2022-08-31T13:46:22.2597575Z ##[debug] "Data": { 2022-08-31T13:46:22.2614007Z ##[debug] "OrganizationType": "Public" 2022-08-31T13:46:22.2632560Z ##[debug] }, 2022-08-31T13:46:22.2680124Z ##[debug] "Auth": { 2022-08-31T13:46:22.2699941Z ##[debug] "parameters": { 2022-08-31T13:46:22.2715979Z ##[debug] "TenantId": "redacted", 2022-08-31T13:46:22.2731120Z ##[debug] "ClientId": "", 2022-08-31T13:46:22.2774020Z ##[debug] "ClientSecret": , 2022-08-31T13:46:22.2790426Z ##[debug] "ClientCertificate": "" 2022-08-31T13:46:22.2806081Z ##[debug] }, 2022-08-31T13:46:22.2836418Z ##[debug] "scheme": "None" 2022-08-31T13:46:22.2838023Z ##[debug] } 2022-08-31T13:46:22.2854275Z ##[debug]} 2022-08-31T13:46:22.5314074Z ##[debug]1:46:22 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2022-08-31T13:46:22.5344781Z ##[debug]1:46:22 PM - Cmdlet version: 1.2.1077.0 2022-08-31T13:46:22.5784823Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/xxx 2022-08-31T13:46:22.6863197Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22] Found 0 cache accounts and 0 broker accounts 2022-08-31T13:46:22.6938241Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4956525c-83c4-4b3d-bd1e-0f511b26db6b) 2022-08-31T13:46:22.6977199Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] === AcquireTokenForClientParameters === 2022-08-31T13:46:22.6992097Z ##[debug]SendX5C: False 2022-08-31T13:46:22.7037475Z ##[debug]WithAzureRegion: False 2022-08-31T13:46:22.7053662Z ##[debug]RegionToUse: 2022-08-31T13:46:22.7068434Z ##[debug]ForceRefresh: False 2022-08-31T13:46:22.7088889Z ##[debug] 2022-08-31T13:46:22.7216038Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] 2022-08-31T13:46:22.7232291Z ##[debug]=== Request Data === 2022-08-31T13:46:22.7311995Z ##[debug]Authority Provided? - True 2022-08-31T13:46:22.7331014Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-08-31T13:46:22.7349311Z ##[debug]Extra Query Params Keys (space separated) - 2022-08-31T13:46:22.7365134Z ##[debug]ApiId - AcquireTokenForClient 2022-08-31T13:46:22.7382181Z ##[debug]IsConfidentialClient - True 2022-08-31T13:46:22.7398476Z ##[debug]SendX5C - False 2022-08-31T13:46:22.7451228Z ##[debug]LoginHint ? False 2022-08-31T13:46:22.7468271Z ##[debug]IsBrokerConfigured - False 2022-08-31T13:46:22.7510875Z ##[debug]HomeAccountId - False 2022-08-31T13:46:22.7531586Z ##[debug]CorrelationId - 4956525c-83c4-4b3d-bd1e-0f511b26db6b 2022-08-31T13:46:22.7550257Z ##[debug] 2022-08-31T13:46:22.7586991Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] === Token Acquisition (ClientCredentialRequest) started: 2022-08-31T13:46:22.7631967Z ##[debug]
2022-08-31T13:46:22.7674816Z ##[debug] Authority Host: login.microsoftonline.com 2022-08-31T13:46:22.8027761Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:22 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Fetching instance discovery from the network from host login.microsoftonline.com. 2022-08-31T13:46:23.3027394Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Resolving authority endpoints... Already resolved? - FALSE 2022-08-31T13:46:23.3067948Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2022-08-31T13:46:23.3123626Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Checking client info returned from the server.. 2022-08-31T13:46:23.3143998Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Saving Token Response to cache.. 2022-08-31T13:46:23.3164444Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] ID Token not present in response. 2022-08-31T13:46:23.3185061Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Saving AT in cache and removing overlapping ATs... 2022-08-31T13:46:23.3204878Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2022-08-31T13:46:23.3252641Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] Intersecting scope entries count - 0 2022-08-31T13:46:23.3278107Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 4956525c-83c4-4b3d-bd1e-0f511b26db6b] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 08/31/2022 14:46:22 +00:00 === 2022-08-31T13:46:23.3300323Z ##[debug]1:46:23 PM - Connect-PowerBIServiceAccount end processing. 2022-08-31T13:46:23.3326282Z ##[debug]INPUT_POWERBIPATH: 'D:\a\r1\a[MyPowerBIFile].pbix' 2022-08-31T13:46:23.3351611Z ##[debug]INPUT_WORKSPACENAME: 'XXX' 2022-08-31T13:46:23.3385376Z ##[debug]INPUT_OVERWRITE: 'true' 2022-08-31T13:46:23.3424210Z ##[debug] Converted to bool: True 2022-08-31T13:46:23.3446479Z ##[debug]INPUT_CREATE: 'false' 2022-08-31T13:46:23.3464658Z ##[debug] Converted to bool: False 2022-08-31T13:46:23.3486394Z ##[debug]INPUT_ACTION: 'Publish' 2022-08-31T13:46:23.3508549Z ##[debug]INPUT_DATASETNAME (empty) 2022-08-31T13:46:23.3553691Z ##[debug]INPUT_OLDURL (empty) 2022-08-31T13:46:23.3592338Z ##[debug]INPUT_NEWURL (empty) 2022-08-31T13:46:23.3652732Z ##[debug]INPUT_OLDSERVER (empty) 2022-08-31T13:46:23.3686020Z ##[debug]INPUT_NEWSERVER (empty) 2022-08-31T13:46:23.3716972Z ##[debug]INPUT_OLDDATABASE (empty) 2022-08-31T13:46:23.3744284Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2022-08-31T13:46:23.3805097Z ##[debug]INPUT_NEWDATABASE (empty) 2022-08-31T13:46:23.3828313Z ##[debug]INPUT_PERMISSION (empty) 2022-08-31T13:46:23.3854861Z ##[debug]INPUT_USERS (empty) 2022-08-31T13:46:23.3890436Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2022-08-31T13:46:23.3950578Z ##[debug]INPUT_UPDATEALL: 'false' 2022-08-31T13:46:23.3971533Z ##[debug] Converted to bool: False 2022-08-31T13:46:23.3995550Z ##[debug]INPUT_SKIPREPORT: 'true' 2022-08-31T13:46:23.4031384Z ##[debug] Converted to bool: True 2022-08-31T13:46:23.4083790Z ##[debug]INPUT_INDIVIDUAL (empty) 2022-08-31T13:46:23.4109910Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2022-08-31T13:46:23.4138624Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2022-08-31T13:46:23.4167384Z ##[debug]INPUT_PARAMETERINPUT (empty) 2022-08-31T13:46:23.4191203Z ##[debug]INPUT_GATEWAYNAME (empty) 2022-08-31T13:46:23.4214312Z ##[debug]INPUT_REPORTNAME (empty) 2022-08-31T13:46:23.4237558Z ##[debug]INPUT_CAPACITYNAME (empty) 2022-08-31T13:46:23.4299613Z ##[debug]INPUT_USERNAME (empty) 2022-08-31T13:46:23.4349889Z ##[debug]INPUT_PASSWORD (empty) 2022-08-31T13:46:23.4377185Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2022-08-31T13:46:23.4411436Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2022-08-31T13:46:23.4687122Z ##[debug] Converted to bool: False 2022-08-31T13:46:23.4714809Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2022-08-31T13:46:23.5064605Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2022-08-31T13:46:23.5086341Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2022-08-31T13:46:23.5103765Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2022-08-31T13:46:23.5137050Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2022-08-31T13:46:23.5168403Z ##[debug]INPUT_DATASETACCESSRIGHT (empty) 2022-08-31T13:46:23.5210959Z ##[debug]WorkspaceName : XXX 2022-08-31T13:46:23.5234294Z ##[debug]Create : False 2022-08-31T13:46:23.5258059Z ##[debug]File patern : D:\a\r1\a[MyPowerBIFile].pbix 2022-08-31T13:46:23.5284347Z ##[debug]Remove report : True 2022-08-31T13:46:23.5538423Z Getting Power BI Workspace properties; XXX 2022-08-31T13:46:23.5598413Z ##[debug]1:46:23 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2022-08-31T13:46:23.5620145Z ##[debug]1:46:23 PM - Cmdlet version: 1.2.1077.0 2022-08-31T13:46:23.5818797Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23] Found 0 cache accounts and 0 broker accounts 2022-08-31T13:46:23.5844467Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(1f31e001-d96d-46db-8c10-2a4d9336e06f) 2022-08-31T13:46:23.5860066Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] === AcquireTokenForClientParameters === 2022-08-31T13:46:23.5873319Z ##[debug]SendX5C: False 2022-08-31T13:46:23.5913906Z ##[debug]WithAzureRegion: False 2022-08-31T13:46:23.5927344Z ##[debug]RegionToUse: 2022-08-31T13:46:23.5940727Z ##[debug]ForceRefresh: False 2022-08-31T13:46:23.5953999Z ##[debug] 2022-08-31T13:46:23.5973173Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] 2022-08-31T13:46:23.6014363Z ##[debug]=== Request Data === 2022-08-31T13:46:23.6027864Z ##[debug]Authority Provided? - True 2022-08-31T13:46:23.6042576Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-08-31T13:46:23.6056686Z ##[debug]Extra Query Params Keys (space separated) - 2022-08-31T13:46:23.6070160Z ##[debug]ApiId - AcquireTokenForClient 2022-08-31T13:46:23.6087033Z ##[debug]IsConfidentialClient - True 2022-08-31T13:46:23.6106586Z ##[debug]SendX5C - False 2022-08-31T13:46:23.6112727Z ##[debug]LoginHint ? False 2022-08-31T13:46:23.6125831Z ##[debug]IsBrokerConfigured - False 2022-08-31T13:46:23.6139612Z ##[debug]HomeAccountId - False 2022-08-31T13:46:23.6153195Z ##[debug]CorrelationId - 1f31e001-d96d-46db-8c10-2a4d9336e06f 2022-08-31T13:46:23.6166568Z ##[debug] 2022-08-31T13:46:23.6185071Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] === Token Acquisition (ClientCredentialRequest) started: 2022-08-31T13:46:23.6217754Z ##[debug]
2022-08-31T13:46:23.6233012Z ##[debug] Authority Host: login.microsoftonline.com 2022-08-31T13:46:23.6338133Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] Access token is not expired. Returning the found cache entry. [Current time (08/31/2022 13:46:23) - Expiration Time (08/31/2022 14:46:22 +00:00) - Extended Expiration Time (08/31/2022 14:46:22 +00:00)] 2022-08-31T13:46:23.6367899Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [08/31/2022 13:46:23 - 1f31e001-d96d-46db-8c10-2a4d9336e06f] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 08/31/2022 14:46:22 +00:00 === 2022-08-31T13:46:24.2029343Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'XXX'&$top=100 2022-08-31T13:46:24.2110747Z ##[debug]Status Code: OK (200) 2022-08-31T13:46:24.2141567Z ##[debug]1:46:24 PM - Get-PowerBIWorkspace end processing. 2022-08-31T13:46:24.2214771Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]redacted 2022-08-31T13:46:24.2283837Z Done processing Power BI Actions 2022-08-31T13:46:24.2284521Z Done running Power BI Actions extension. 2022-08-31T13:46:24.2289293Z ##[debug]Leaving D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-08-31T13:46:24.3555648Z ##[section]Finishing: Power BI Action: Publish

maikvandergaag commented 1 year ago

HI @99Wasdqwop,

It looks like you did not configure correctly to point to the report. You logs shows that it did not try to deploy a report the problem could be because you did not point it correctly to a pbix file.

99Wasdqwop commented 1 year ago

Hi Maik,

Thank you for your response. In that case I'm not sure how to configure it correctly. There seems to be no option to point at a target .pbix file?

Below is a screenshot of the interface - all I can select is a "source" .pbix file. I assumed it would target a pbix file with the same name in the target, but if that's not the case, I'd love to know where to configure that. image

Best regards.

maikvandergaag commented 1 year ago

This seems to be correct would you mind setting create workspace when it does not exists and do a run and if it does not work send me the logs?

And are you sure there should be a file under that path

99Wasdqwop commented 1 year ago

Yes I'm sure the file is under that path. I've verified by changing file names and checking if the new updated version of the file showed up there, and by downloading the file and manually checking its version.

I've ran it again by setting the create workspace when it does not exist, although Im not sure that's something I necessarily want it to do. Anyway, the result is the same. Here's the log:

2022-09-03T09:06:24.8987638Z ##[debug]Evaluating condition for step: 'Power BI Action: Publish' 2022-09-03T09:06:24.8989453Z ##[debug]Evaluating: succeeded() 2022-09-03T09:06:24.8989902Z ##[debug]Evaluating succeeded: 2022-09-03T09:06:24.8991126Z ##[debug]=> True 2022-09-03T09:06:24.8992159Z ##[debug]Result: True 2022-09-03T09:06:24.8992592Z ##[section]Starting: Power BI Action: Publish 2022-09-03T09:06:24.9146179Z ============================================================================== 2022-09-03T09:06:24.9146453Z Task : Power BI Actions 2022-09-03T09:06:24.9146664Z Description : Release Task Power BI Actions 2022-09-03T09:06:24.9146884Z Version : 5.4.39 2022-09-03T09:06:24.9147446Z Author : Maik van der Gaag 2022-09-03T09:06:24.9148190Z Help : 2022-09-03T09:06:24.9148408Z ============================================================================== 2022-09-03T09:06:26.0271924Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2022-09-03T09:06:26.1942537Z Starting Power BI Actions extension 2022-09-03T09:06:26.2124174Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-09-03T09:06:26.2224996Z ### Required Module is needed. Importing now... 2022-09-03T09:06:26.2260165Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2022-09-03T09:06:26.2355313Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2022-09-03T09:06:26.2411065Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2022-09-03T09:06:26.3825948Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2022-09-03T09:06:26.3890039Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2022-09-03T09:06:26.4092131Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-03T09:06:26.4121282Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-03T09:06:26.4146461Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2022-09-03T09:06:26.4173503Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-03T09:06:26.4196907Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2022-09-03T09:06:26.4224178Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-03T09:06:26.4248333Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-03T09:06:26.4293800Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2022-09-03T09:06:26.4294447Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-03T09:06:26.4371527Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2022-09-03T09:06:26.4398353Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2022-09-03T09:06:26.4425162Z ##[debug]Importing alias 'Login-PowerBI'. 2022-09-03T09:06:26.4447456Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2022-09-03T09:06:26.4471692Z ##[debug]Importing alias 'Logout-PowerBI'. 2022-09-03T09:06:26.4496059Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2022-09-03T09:06:26.4521099Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2022-09-03T09:06:26.4544020Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2022-09-03T09:06:26.4585834Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2022-09-03T09:06:26.4674518Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2022-09-03T09:06:26.4911959Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2022-09-03T09:06:26.4990543Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2022-09-03T09:06:26.5078523Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-03T09:06:26.5109083Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2022-09-03T09:06:26.5282511Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-03T09:06:26.5634265Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2022-09-03T09:06:26.6816307Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-03T09:06:26.6842940Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2022-09-03T09:06:26.6867498Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2022-09-03T09:06:26.6890049Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-03T09:06:26.6910923Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2022-09-03T09:06:26.6917518Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-03T09:06:26.6936039Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2022-09-03T09:06:26.6957205Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-03T09:06:26.6973709Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2022-09-03T09:06:26.7000630Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2022-09-03T09:06:26.7029056Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2022-09-03T09:06:26.7056573Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2022-09-03T09:06:26.7077511Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2022-09-03T09:06:26.7098770Z ##[debug]Importing alias 'New-PowerBIGroup'. 2022-09-03T09:06:26.7122038Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2022-09-03T09:06:26.7141109Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2022-09-03T09:06:26.7163865Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2022-09-03T09:06:26.7197823Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2022-09-03T09:06:26.7319450Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2022-09-03T09:06:26.7347288Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2022-09-03T09:06:26.7407506Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2022-09-03T09:06:26.7439704Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2022-09-03T09:06:26.7461427Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2022-09-03T09:06:26.7480377Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2022-09-03T09:06:26.7528607Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2022-09-03T09:06:26.7652226Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2022-09-03T09:06:26.7701690Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2022-09-03T09:06:26.7723757Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2022-09-03T09:06:26.7742739Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2022-09-03T09:06:26.7784036Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2022-09-03T09:06:26.7802128Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2022-09-03T09:06:26.7851776Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2022-09-03T09:06:26.7909845Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2022-09-03T09:06:26.7911124Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2022-09-03T09:06:26.7928792Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2022-09-03T09:06:26.7971195Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2022-09-03T09:06:26.7990180Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2022-09-03T09:06:26.8014526Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2022-09-03T09:06:26.8066765Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2022-09-03T09:06:26.8072143Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2022-09-03T09:06:26.8097806Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2022-09-03T09:06:26.8131937Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2022-09-03T09:06:26.8205343Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2022-09-03T09:06:26.8630830Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2022-09-03T09:06:26.8688791Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2022-09-03T09:06:26.8753703Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2022-09-03T09:06:26.8805483Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2022-09-03T09:06:26.8827330Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2022-09-03T09:06:26.8845995Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2022-09-03T09:06:26.8877115Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-03T09:06:26.8942641Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2022-09-03T09:06:26.8968231Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2022-09-03T09:06:26.8996269Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2022-09-03T09:06:26.9017736Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2022-09-03T09:06:26.9045112Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2022-09-03T09:06:26.9245099Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2022-09-03T09:06:26.9246296Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2022-09-03T09:06:26.9247308Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2022-09-03T09:06:26.9248588Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2022-09-03T09:06:26.9249499Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2022-09-03T09:06:26.9250384Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2022-09-03T09:06:26.9251264Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2022-09-03T09:06:26.9255883Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2022-09-03T09:06:26.9307710Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-03T09:06:26.9344856Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2022-09-03T09:06:26.9389479Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2022-09-03T09:06:26.9419423Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2022-09-03T09:06:26.9440155Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2022-09-03T09:06:26.9485552Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2022-09-03T09:06:26.9508579Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2022-09-03T09:06:26.9556766Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2022-09-03T09:06:26.9580441Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2022-09-03T09:06:26.9605027Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2022-09-03T09:06:26.9636303Z ### Trying to import the incorporated module for PowerBI 2022-09-03T09:06:26.9669653Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'. 2022-09-03T09:06:27.0151257Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-03T09:06:27.0258003Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-03T09:06:27.0292407Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2022-09-03T09:06:27.0308888Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-03T09:06:27.0327935Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2022-09-03T09:06:27.0382618Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2022-09-03T09:06:27.0421355Z ##[debug]Exporting function 'Set-DatasetOwnersXXX'. 2022-09-03T09:06:27.0468047Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnersXXX'. 2022-09-03T09:06:27.0493915Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2022-09-03T09:06:27.0516639Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2022-09-03T09:06:27.0535369Z ##[debug]Exporting function 'Invoke-API'. 2022-09-03T09:06:27.0598283Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2022-09-03T09:06:27.0654919Z ##[debug]Exporting function 'New-DatasetRefresh'. 2022-09-03T09:06:27.0679393Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2022-09-03T09:06:27.0722373Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2022-09-03T09:06:27.0744317Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2022-09-03T09:06:27.0795144Z ##[debug]Exporting function 'Get-PowerBIReport'. 2022-09-03T09:06:27.0837803Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2022-09-03T09:06:27.0860031Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2022-09-03T09:06:27.0891486Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2022-09-03T09:06:27.0917410Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2022-09-03T09:06:27.0962519Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2022-09-03T09:06:27.0997425Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2022-09-03T09:06:27.1022819Z ##[debug]Exporting function 'Import-PowerBIFile'. 2022-09-03T09:06:27.1041966Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2022-09-03T09:06:27.1101243Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2022-09-03T09:06:27.1147958Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2022-09-03T09:06:27.1180324Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2022-09-03T09:06:27.1205088Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2022-09-03T09:06:27.1226629Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2022-09-03T09:06:27.1246909Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2022-09-03T09:06:27.1276325Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2022-09-03T09:06:27.1348781Z ##[debug]Exporting function 'Set-Capacity'. 2022-09-03T09:06:27.1379708Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2022-09-03T09:06:27.1401032Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-03T09:06:27.1420686Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2022-09-03T09:06:27.1450007Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2022-09-03T09:06:27.1471934Z ##[debug]Exporting function 'Publish-TabularEditor'. 2022-09-03T09:06:27.1513825Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2022-09-03T09:06:27.1537292Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2022-09-03T09:06:27.1625892Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2022-09-03T09:06:27.1681815Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2022-09-03T09:06:27.1705238Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2022-09-03T09:06:27.1729194Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2022-09-03T09:06:27.1748367Z ##[debug]Importing function 'Get-PowerBICapacity'. 2022-09-03T09:06:27.1770961Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2022-09-03T09:06:27.1862669Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2022-09-03T09:06:27.1884252Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-03T09:06:27.1919056Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2022-09-03T09:06:27.1947153Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2022-09-03T09:06:27.1967079Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2022-09-03T09:06:27.1986887Z ##[debug]Importing function 'Get-PowerBIGateways'. 2022-09-03T09:06:27.2037809Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2022-09-03T09:06:27.2077121Z ##[debug]Importing function 'Get-PowerBiParameters'. 2022-09-03T09:06:27.2124213Z ##[debug]Importing function 'Get-PowerBIReport'. 2022-09-03T09:06:27.2146101Z ##[debug]Importing function 'Import-PowerBIFile'. 2022-09-03T09:06:27.2186056Z ##[debug]Importing function 'Invoke-API'. 2022-09-03T09:06:27.2215862Z ##[debug]Importing function 'New-DatasetRefresh'. 2022-09-03T09:06:27.2236876Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2022-09-03T09:06:27.2257347Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2022-09-03T09:06:27.2279984Z ##[debug]Importing function 'Publish-PowerBIFile'. 2022-09-03T09:06:27.2312191Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2022-09-03T09:06:27.2332251Z ##[debug]Importing function 'Publish-TabularEditor'. 2022-09-03T09:06:27.2351104Z ##[debug]Importing function 'Redo-PowerBIReport'. 2022-09-03T09:06:27.2383895Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-03T09:06:27.2419268Z ##[debug]Importing function 'Remove-PowerBIReport'. 2022-09-03T09:06:27.2446697Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2022-09-03T09:06:27.2469346Z ##[debug]Importing function 'Set-Capacity'. 2022-09-03T09:06:27.2497548Z ##[debug]Importing function 'Set-DatasetOwnersXXX'. 2022-09-03T09:06:27.2515561Z ##[debug]Importing function 'Set-PowerBIDataSetOwnersXXX'. 2022-09-03T09:06:27.2541301Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-03T09:06:27.2578665Z ##[debug]Importing function 'Set-RefreshSchedule'. 2022-09-03T09:06:27.2604777Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2022-09-03T09:06:27.2626006Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2022-09-03T09:06:27.2646139Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2022-09-03T09:06:27.2685616Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2022-09-03T09:06:27.2719830Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-03T09:06:27.2760453Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2022-09-03T09:06:27.2781188Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2022-09-03T09:06:27.2800763Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2022-09-03T09:06:27.3225713Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '9cf83ac7-2732-4f09-8cde-a98481e56b9e' 2022-09-03T09:06:27.3369134Z ##[debug]ENDPOINT_URL_9cf83ac7-2732-4f09-8cde-a98481e56b9e: 'https://api.powerbi.com/v1.0/myorg' 2022-09-03T09:06:27.3402414Z ##[debug]ENDPOINT_AUTH_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '****' 2022-09-03T09:06:27.3470756Z ##[debug]ENDPOINT_DATA_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '{"OrganizationType":"Public"}' 2022-09-03T09:06:27.3649542Z ##[debug]{ 2022-09-03T09:06:27.3666695Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2022-09-03T09:06:27.3743875Z ##[debug] "Data": { 2022-09-03T09:06:27.3744784Z ##[debug] "OrganizationType": "Public" 2022-09-03T09:06:27.3748871Z ##[debug] }, 2022-09-03T09:06:27.3764344Z ##[debug] "Auth": { 2022-09-03T09:06:27.3810653Z ##[debug] "parameters": { 2022-09-03T09:06:27.3829095Z ##[debug] "TenantId": "xxx", 2022-09-03T09:06:27.3845870Z ##[debug] "ClientId": "", 2022-09-03T09:06:27.3861310Z ##[debug] "ClientSecret": , 2022-09-03T09:06:27.3876227Z ##[debug] "ClientCertificate": "" 2022-09-03T09:06:27.3979486Z ##[debug] }, 2022-09-03T09:06:27.3997028Z ##[debug] "scheme": "None" 2022-09-03T09:06:27.4067301Z ##[debug] } 2022-09-03T09:06:27.4097240Z ##[debug]} 2022-09-03T09:06:27.6743116Z ##[debug]9:06:27 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2022-09-03T09:06:27.6785933Z ##[debug]9:06:27 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:27.7167200Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/xxx 2022-09-03T09:06:27.8289321Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:27.8377368Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(e42c5666-2077-4a4b-9c31-dbe1075a9fa3) 2022-09-03T09:06:27.8413991Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] === AcquireTokenForClientParameters === 2022-09-03T09:06:27.8429927Z ##[debug]SendX5C: False 2022-09-03T09:06:27.8443797Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:27.8458941Z ##[debug]RegionToUse: 2022-09-03T09:06:27.8478012Z ##[debug]ForceRefresh: False 2022-09-03T09:06:27.8522260Z ##[debug] 2022-09-03T09:06:27.8662292Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] 2022-09-03T09:06:27.8679306Z ##[debug]=== Request Data === 2022-09-03T09:06:27.8699901Z ##[debug]Authority Provided? - True 2022-09-03T09:06:27.8715350Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:27.8732276Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:27.8775777Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:27.8825295Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:27.8844700Z ##[debug]SendX5C - False 2022-09-03T09:06:27.8894178Z ##[debug]LoginHint ? False 2022-09-03T09:06:27.8918194Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:27.8936873Z ##[debug]HomeAccountId - False 2022-09-03T09:06:27.8954749Z ##[debug]CorrelationId - e42c5666-2077-4a4b-9c31-dbe1075a9fa3 2022-09-03T09:06:27.8979153Z ##[debug] 2022-09-03T09:06:27.9026543Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:27.9044714Z ##[debug]
2022-09-03T09:06:27.9060471Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:27.9450483Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:27 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Fetching instance discovery from the network from host login.microsoftonline.com. 2022-09-03T09:06:28.4909221Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Resolving authority endpoints... Already resolved? - FALSE 2022-09-03T09:06:28.4936607Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2022-09-03T09:06:28.4974261Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Checking client info returned from the server.. 2022-09-03T09:06:28.4994300Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Saving Token Response to cache.. 2022-09-03T09:06:28.5018257Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] ID Token not present in response. 2022-09-03T09:06:28.5040510Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Saving AT in cache and removing overlapping ATs... 2022-09-03T09:06:28.5077789Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:28.5100434Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] Intersecting scope entries count - 0 2022-09-03T09:06:28.5128983Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - e42c5666-2077-4a4b-9c31-dbe1075a9fa3] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:27 +00:00 === 2022-09-03T09:06:28.5158893Z ##[debug]9:06:28 AM - Connect-PowerBIServiceAccount end processing. 2022-09-03T09:06:28.5190036Z ##[debug]INPUTPOWERBIPATH: 'D:\a\r1\a\[PowerBI]XXX]XXX_Monitoring_ACC.pbix' 2022-09-03T09:06:28.5216545Z ##[debug]INPUT_WORKSPACENAME: 'WorkspaceName' 2022-09-03T09:06:28.5244656Z ##[debug]INPUT_OVERWRITE: 'true' 2022-09-03T09:06:28.5291956Z ##[debug] Converted to bool: True 2022-09-03T09:06:28.5316662Z ##[debug]INPUT_CREATE: 'true' 2022-09-03T09:06:28.5360672Z ##[debug] Converted to bool: True 2022-09-03T09:06:28.5386698Z ##[debug]INPUT_ACTION: 'Publish' 2022-09-03T09:06:28.5439065Z ##[debug]INPUT_DATASETNAME (empty) 2022-09-03T09:06:28.5530998Z ##[debug]INPUT_OLDURL (empty) 2022-09-03T09:06:28.5576447Z ##[debug]INPUT_NEWURL (empty) 2022-09-03T09:06:28.5600822Z ##[debug]INPUT_OLDSERVER (empty) 2022-09-03T09:06:28.5628542Z ##[debug]INPUT_NEWSERVER (empty) 2022-09-03T09:06:28.5654194Z ##[debug]INPUT_OLDDATABASE (empty) 2022-09-03T09:06:28.5676972Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2022-09-03T09:06:28.5701190Z ##[debug]INPUT_NEWDATABASE (empty) 2022-09-03T09:06:28.5726015Z ##[debug]INPUT_PERMISSION (empty) 2022-09-03T09:06:28.5749701Z ##[debug]INPUT_USERS (empty) 2022-09-03T09:06:28.5775796Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2022-09-03T09:06:28.5801717Z ##[debug]INPUT_UPDATEALL: 'false' 2022-09-03T09:06:28.5822672Z ##[debug] Converted to bool: False 2022-09-03T09:06:28.5857195Z ##[debug]INPUT_SKIPREPORT: 'false' 2022-09-03T09:06:28.5880614Z ##[debug] Converted to bool: False 2022-09-03T09:06:28.5908541Z ##[debug]INPUT_INDIVIDUAL (empty) 2022-09-03T09:06:28.5942681Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2022-09-03T09:06:28.5977638Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2022-09-03T09:06:28.6044492Z ##[debug]INPUT_PARAMETERINPUT (empty) 2022-09-03T09:06:28.6088196Z ##[debug]INPUT_GATEWAYNAME (empty) 2022-09-03T09:06:28.6171768Z ##[debug]INPUT_REPORTNAME (empty) 2022-09-03T09:06:28.6232138Z ##[debug]INPUT_CAPACITYNAME (empty) 2022-09-03T09:06:28.6285618Z ##[debug]INPUT_USERNAME (empty) 2022-09-03T09:06:28.6327824Z ##[debug]INPUT_PASSWORD (empty) 2022-09-03T09:06:28.6441941Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2022-09-03T09:06:28.6992428Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2022-09-03T09:06:28.7073275Z ##[debug] Converted to bool: False 2022-09-03T09:06:28.7151823Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2022-09-03T09:06:28.7515802Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2022-09-03T09:06:28.7582848Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2022-09-03T09:06:28.7635066Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2022-09-03T09:06:28.7679703Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2022-09-03T09:06:28.7750028Z ##[debug]INPUTDATASETACCESSRIGHT (empty) 2022-09-03T09:06:28.7765403Z ##[debug]WorkspaceName : WorkspaceName 2022-09-03T09:06:28.7793152Z ##[debug]Create : True 2022-09-03T09:06:28.7894535Z ##[debug]File patern : D:\a\r1\a\[PowerBI]XXX\XXX_Monitoring_ACC.pbix 2022-09-03T09:06:28.7923421Z ##[debug]Remove report : False 2022-09-03T09:06:28.8202049Z Getting Power BI Workspace properties; WorkspaceName 2022-09-03T09:06:28.8303061Z ##[debug]9:06:28 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2022-09-03T09:06:28.8321386Z ##[debug]9:06:28 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:28.8527409Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:28.8563967Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(373e61ce-24fc-4a75-b8a2-226b28044383) 2022-09-03T09:06:28.8582374Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] === AcquireTokenForClientParameters === 2022-09-03T09:06:28.8596158Z ##[debug]SendX5C: False 2022-09-03T09:06:28.8632768Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:28.8657185Z ##[debug]RegionToUse: 2022-09-03T09:06:28.8675723Z ##[debug]ForceRefresh: False 2022-09-03T09:06:28.8687902Z ##[debug] 2022-09-03T09:06:28.8712503Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] 2022-09-03T09:06:28.8728290Z ##[debug]=== Request Data === 2022-09-03T09:06:28.8745212Z ##[debug]Authority Provided? - True 2022-09-03T09:06:28.8780002Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:28.8796815Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:28.8812935Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:28.8847471Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:28.8864218Z ##[debug]SendX5C - False 2022-09-03T09:06:28.8889595Z ##[debug]LoginHint ? False 2022-09-03T09:06:28.8903490Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:28.8930593Z ##[debug]HomeAccountId - False 2022-09-03T09:06:28.8946462Z ##[debug]CorrelationId - 373e61ce-24fc-4a75-b8a2-226b28044383 2022-09-03T09:06:28.8983522Z ##[debug] 2022-09-03T09:06:28.9008155Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:28.9029641Z ##[debug]
2022-09-03T09:06:28.9029641Z ##[debug]
2022-09-03T09:06:28.9073556Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:28.9169576Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] Access token is not expired. Returning the found cache entry. [Current time (09/03/2022 09:06:28) - Expiration Time (09/03/2022 10:06:27 +00:00) - Extended Expiration Time (09/03/2022 10:06:27 +00:00)] 2022-09-03T09:06:28.9199714Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:28 - 373e61ce-24fc-4a75-b8a2-226b28044383] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:27 +00:00 === 2022-09-03T09:06:29.4992706Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'WorkspaceName'&$top=100 2022-09-03T09:06:29.5013716Z ##[debug]Status Code: OK (200) 2022-09-03T09:06:29.5038051Z ##[debug]9:06:29 AM - Get-PowerBIWorkspace end processing. 2022-09-03T09:06:29.5125575Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]90a2e4bf-7f42-4aaf-826b-8df2c27db93c 2022-09-03T09:06:29.5154565Z ##[debug]9:06:29 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2022-09-03T09:06:29.5176958Z ##[debug]9:06:29 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:29.5206148Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:29.5252176Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc) 2022-09-03T09:06:29.5299469Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] === AcquireTokenForClientParameters === 2022-09-03T09:06:29.5315746Z ##[debug]SendX5C: False 2022-09-03T09:06:29.5332901Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:29.5350467Z ##[debug]RegionToUse: 2022-09-03T09:06:29.5371839Z ##[debug]ForceRefresh: False 2022-09-03T09:06:29.5390997Z ##[debug] 2022-09-03T09:06:29.5420616Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] 2022-09-03T09:06:29.5473111Z ##[debug]=== Request Data === 2022-09-03T09:06:29.5489663Z ##[debug]Authority Provided? - True 2022-09-03T09:06:29.5505496Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:29.5525026Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:29.5565963Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:29.5581987Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:29.5598184Z ##[debug]SendX5C - False 2022-09-03T09:06:29.5615183Z ##[debug]LoginHint ? False 2022-09-03T09:06:29.5629533Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:29.5686733Z ##[debug]HomeAccountId - False 2022-09-03T09:06:29.5740177Z ##[debug]CorrelationId - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc 2022-09-03T09:06:29.5816552Z ##[debug] 2022-09-03T09:06:29.5839570Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:29.5891112Z ##[debug]
2022-09-03T09:06:29.5924776Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:29.5962145Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] Access token is not expired. Returning the found cache entry. [Current time (09/03/2022 09:06:29) - Expiration Time (09/03/2022 10:06:27 +00:00) - Extended Expiration Time (09/03/2022 10:06:27 +00:00)] 2022-09-03T09:06:29.6013848Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:29 - c4dd4c72-05b2-4faa-ba03-e7b88c6e0acc] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:27 +00:00 === 2022-09-03T09:06:29.7917447Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'WorkspaceName'&$top=100 2022-09-03T09:06:29.7943524Z ##[debug]Status Code: OK (200) 2022-09-03T09:06:29.7963278Z ##[debug]9:06:29 AM - Get-PowerBIWorkspace end processing. 2022-09-03T09:06:29.7989498Z Done processing Power BI Actions 2022-09-03T09:06:29.7993823Z Done running Power BI Actions extension. 2022-09-03T09:06:29.8056643Z ##[debug]Leaving D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-09-03T09:06:29.8513763Z ##[section]Finishing: Power BI Action: Publish

maikvandergaag commented 1 year ago

For some reason the PowerBI execution stops after getting the workspaces. What is strange the only reason could be due to the fact it can not find any.

What kind of authentication are you using?

99Wasdqwop commented 1 year ago

Strange. I use a service principal. For the sake of testing I tried using a username/pw authentication but it throws me an error that I need to use multifactor auth, so that doesnt work.

It might help to show you the debug log of the next step. It's where I refresh the dataset that I just "failed" to update. But the refreshing works just fine (same authentication):

2022-09-03T09:06:29.8594808Z ##[debug]Evaluating condition for step: 'Power BI Action: Refresh dataset' 2022-09-03T09:06:29.8596834Z ##[debug]Evaluating: succeeded() 2022-09-03T09:06:29.8597287Z ##[debug]Evaluating succeeded: 2022-09-03T09:06:29.8598540Z ##[debug]=> True 2022-09-03T09:06:29.8598984Z ##[debug]Result: True 2022-09-03T09:06:29.8599398Z ##[section]Starting: Power BI Action: Refresh dataset 2022-09-03T09:06:29.8770644Z ============================================================================== 2022-09-03T09:06:29.8770909Z Task : Power BI Actions 2022-09-03T09:06:29.8771103Z Description : Release Task Power BI Actions 2022-09-03T09:06:29.8771289Z Version : 5.4.39 2022-09-03T09:06:29.8771456Z Author : Maik van der Gaag 2022-09-03T09:06:29.8771627Z Help : 2022-09-03T09:06:29.8771824Z ============================================================================== 2022-09-03T09:06:30.7670506Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c 2022-09-03T09:06:30.9276813Z Starting Power BI Actions extension 2022-09-03T09:06:30.9398587Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-09-03T09:06:30.9481603Z ### Required Module is needed. Importing now... 2022-09-03T09:06:30.9538088Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'. 2022-09-03T09:06:30.9676851Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'. 2022-09-03T09:06:30.9678728Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'. 2022-09-03T09:06:31.0016459Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile. 2022-09-03T09:06:31.0048438Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'. 2022-09-03T09:06:31.0177117Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-03T09:06:31.0220893Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-03T09:06:31.0254106Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'. 2022-09-03T09:06:31.0352195Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-03T09:06:31.0398393Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'. 2022-09-03T09:06:31.0399049Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'. 2022-09-03T09:06:31.0424249Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'. 2022-09-03T09:06:31.0475039Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'. 2022-09-03T09:06:31.0476300Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'. 2022-09-03T09:06:31.0499415Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'. 2022-09-03T09:06:31.0530851Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'. 2022-09-03T09:06:31.0575610Z ##[debug]Importing alias 'Login-PowerBI'. 2022-09-03T09:06:31.0595866Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'. 2022-09-03T09:06:31.0655909Z ##[debug]Importing alias 'Logout-PowerBI'. 2022-09-03T09:06:31.0677389Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'. 2022-09-03T09:06:31.0708717Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'. 2022-09-03T09:06:31.0772165Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'. 2022-09-03T09:06:31.0830196Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'. 2022-09-03T09:06:31.0930093Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'. 2022-09-03T09:06:31.1173246Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces. 2022-09-03T09:06:31.1216605Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'. 2022-09-03T09:06:31.1311646Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-03T09:06:31.1395148Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'. 2022-09-03T09:06:31.1417568Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-03T09:06:31.1439434Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'. 2022-09-03T09:06:31.2397334Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-03T09:06:31.2434126Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'. 2022-09-03T09:06:31.2441528Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'. 2022-09-03T09:06:31.2465237Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'. 2022-09-03T09:06:31.2484789Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'. 2022-09-03T09:06:31.2505530Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'. 2022-09-03T09:06:31.2524256Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'. 2022-09-03T09:06:31.2544095Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'. 2022-09-03T09:06:31.2566346Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'. 2022-09-03T09:06:31.2588428Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'. 2022-09-03T09:06:31.2609175Z ##[debug]Importing alias 'Add-PowerBIGroupUser'. 2022-09-03T09:06:31.2630644Z ##[debug]Importing alias 'Get-PowerBIGroup'. 2022-09-03T09:06:31.2653599Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'. 2022-09-03T09:06:31.2677844Z ##[debug]Importing alias 'New-PowerBIGroup'. 2022-09-03T09:06:31.2708972Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'. 2022-09-03T09:06:31.2728599Z ##[debug]Importing alias 'Restore-PowerBIGroup'. 2022-09-03T09:06:31.2751080Z ##[debug]Importing alias 'Set-PowerBIGroup'. 2022-09-03T09:06:31.2796624Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'. 2022-09-03T09:06:31.2864742Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports. 2022-09-03T09:06:31.2911811Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'. 2022-09-03T09:06:31.2990798Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'. 2022-09-03T09:06:31.3010264Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'. 2022-09-03T09:06:31.3031514Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'. 2022-09-03T09:06:31.3055380Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'. 2022-09-03T09:06:31.3079104Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'. 2022-09-03T09:06:31.3098837Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'. 2022-09-03T09:06:31.3125168Z ##[debug]Exporting cmdlet 'Get-PowerBITile'. 2022-09-03T09:06:31.3147179Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'. 2022-09-03T09:06:31.3174756Z ##[debug]Exporting cmdlet 'New-PowerBIReport'. 2022-09-03T09:06:31.3199158Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'. 2022-09-03T09:06:31.3224003Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'. 2022-09-03T09:06:31.3243928Z ##[debug]Importing cmdlet 'Copy-PowerBITile'. 2022-09-03T09:06:31.3263197Z ##[debug]Importing cmdlet 'Export-PowerBIReport'. 2022-09-03T09:06:31.3291047Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'. 2022-09-03T09:06:31.3312216Z ##[debug]Importing cmdlet 'Get-PowerBIImport'. 2022-09-03T09:06:31.3333693Z ##[debug]Importing cmdlet 'Get-PowerBIReport'. 2022-09-03T09:06:31.3358977Z ##[debug]Importing cmdlet 'Get-PowerBITile'. 2022-09-03T09:06:31.3376840Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'. 2022-09-03T09:06:31.3397251Z ##[debug]Importing cmdlet 'New-PowerBIReport'. 2022-09-03T09:06:31.3442781Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'. 2022-09-03T09:06:31.3461630Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'. 2022-09-03T09:06:31.3526095Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'. 2022-09-03T09:06:31.3599026Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'. 2022-09-03T09:06:31.3892777Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data. 2022-09-03T09:06:31.3922993Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'. 2022-09-03T09:06:31.3982256Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'. 2022-09-03T09:06:31.4029500Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'. 2022-09-03T09:06:31.4049304Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'. 2022-09-03T09:06:31.4070627Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'. 2022-09-03T09:06:31.4093112Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-03T09:06:31.4114288Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'. 2022-09-03T09:06:31.4137463Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'. 2022-09-03T09:06:31.4196284Z ##[debug]Exporting cmdlet 'Get-PowerBITable'. 2022-09-03T09:06:31.4216821Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'. 2022-09-03T09:06:31.4241755Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'. 2022-09-03T09:06:31.4267948Z ##[debug]Exporting cmdlet 'New-PowerBITable'. 2022-09-03T09:06:31.4295912Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'. 2022-09-03T09:06:31.4315209Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'. 2022-09-03T09:06:31.4335782Z ##[debug]Exporting cmdlet 'Set-PowerBITable'. 2022-09-03T09:06:31.4358390Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'. 2022-09-03T09:06:31.5115179Z ##[debug]Importing cmdlet 'Add-PowerBIRow'. 2022-09-03T09:06:31.5133462Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'. 2022-09-03T09:06:31.5154592Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'. 2022-09-03T09:06:31.5182074Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'. 2022-09-03T09:06:31.5204031Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'. 2022-09-03T09:06:31.5223727Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'. 2022-09-03T09:06:31.5245185Z ##[debug]Importing cmdlet 'Get-PowerBITable'. 2022-09-03T09:06:31.5266646Z ##[debug]Importing cmdlet 'New-PowerBIColumn'. 2022-09-03T09:06:31.5285268Z ##[debug]Importing cmdlet 'New-PowerBIDataset'. 2022-09-03T09:06:31.5310736Z ##[debug]Importing cmdlet 'New-PowerBITable'. 2022-09-03T09:06:31.5329315Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'. 2022-09-03T09:06:31.5347475Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'. 2022-09-03T09:06:31.5367721Z ##[debug]Importing cmdlet 'Set-PowerBITable'. 2022-09-03T09:06:31.5383636Z ### Trying to import the incorporated module for PowerBI 2022-09-03T09:06:31.5435046Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'. 2022-09-03T09:06:31.5697668Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-03T09:06:31.5723840Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-03T09:06:31.5783350Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'. 2022-09-03T09:06:31.5803752Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-03T09:06:31.5825262Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'. 2022-09-03T09:06:31.5848862Z ##[debug]Exporting function 'Get-PowerBIGateways'. 2022-09-03T09:06:31.5903077Z ##[debug]Exporting function 'Set-DatasetOwnersXXX'. 2022-09-03T09:06:31.5922138Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnersXXX'. 2022-09-03T09:06:31.5947016Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'. 2022-09-03T09:06:31.5979663Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'. 2022-09-03T09:06:31.6022062Z ##[debug]Exporting function 'Invoke-API'. 2022-09-03T09:06:31.6042734Z ##[debug]Exporting function 'New-DataSetSingleRefresh'. 2022-09-03T09:06:31.6064430Z ##[debug]Exporting function 'New-DatasetRefresh'. 2022-09-03T09:06:31.6116552Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'. 2022-09-03T09:06:31.6136307Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'. 2022-09-03T09:06:31.6180887Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'. 2022-09-03T09:06:31.6203514Z ##[debug]Exporting function 'Get-PowerBIReport'. 2022-09-03T09:06:31.6224817Z ##[debug]Exporting function 'Get-PowerBiDataSet'. 2022-09-03T09:06:31.6248028Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'. 2022-09-03T09:06:31.6348392Z ##[debug]Exporting function 'Get-PowerBiDataSets'. 2022-09-03T09:06:31.6349757Z ##[debug]Exporting function 'Get-PowerBiParameters'. 2022-09-03T09:06:31.6350443Z ##[debug]Exporting function 'New-PowerBIWorkSpace'. 2022-09-03T09:06:31.6360211Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'. 2022-09-03T09:06:31.6386575Z ##[debug]Exporting function 'Import-PowerBIFile'. 2022-09-03T09:06:31.6407476Z ##[debug]Exporting function 'Get-PowerBIGroupPath'. 2022-09-03T09:06:31.6428409Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'. 2022-09-03T09:06:31.6487543Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'. 2022-09-03T09:06:31.6495526Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'. 2022-09-03T09:06:31.6525013Z ##[debug]Exporting function 'Publish-PowerBIFile'. 2022-09-03T09:06:31.6569335Z ##[debug]Exporting function 'Publish-PowerBIFileApi'. 2022-09-03T09:06:31.6597437Z ##[debug]Exporting function 'Remove-PowerBIReport'. 2022-09-03T09:06:31.6621739Z ##[debug]Exporting function 'Get-PowerBICapacity'. 2022-09-03T09:06:31.6684308Z ##[debug]Exporting function 'Set-Capacity'. 2022-09-03T09:06:31.6694267Z ##[debug]Exporting function 'Redo-PowerBIReport'. 2022-09-03T09:06:31.6738362Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-03T09:06:31.6796406Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'. 2022-09-03T09:06:31.6817013Z ##[debug]Exporting function 'Set-RefreshSchedule'. 2022-09-03T09:06:31.6833829Z ##[debug]Exporting function 'Publish-TabularEditor'. 2022-09-03T09:06:31.6897933Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'. 2022-09-03T09:06:31.6947820Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'. 2022-09-03T09:06:31.6970693Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'. 2022-09-03T09:06:31.6990065Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'. 2022-09-03T09:06:31.7011485Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'. 2022-09-03T09:06:31.7052349Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'. 2022-09-03T09:06:31.7072342Z ##[debug]Importing function 'Get-PowerBICapacity'. 2022-09-03T09:06:31.7091552Z ##[debug]Importing function 'Get-PowerBiDataSet'. 2022-09-03T09:06:31.7122192Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'. 2022-09-03T09:06:31.7197936Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'. 2022-09-03T09:06:31.7218853Z ##[debug]Importing function 'Get-PowerBiDataSets'. 2022-09-03T09:06:31.7238505Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'. 2022-09-03T09:06:31.7261383Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'. 2022-09-03T09:06:31.7281660Z ##[debug]Importing function 'Get-PowerBIGateways'. 2022-09-03T09:06:31.7317086Z ##[debug]Importing function 'Get-PowerBIGroupPath'. 2022-09-03T09:06:31.7343301Z ##[debug]Importing function 'Get-PowerBiParameters'. 2022-09-03T09:06:31.7366702Z ##[debug]Importing function 'Get-PowerBIReport'. 2022-09-03T09:06:31.7384380Z ##[debug]Importing function 'Import-PowerBIFile'. 2022-09-03T09:06:31.7406064Z ##[debug]Importing function 'Invoke-API'. 2022-09-03T09:06:31.7425614Z ##[debug]Importing function 'New-DatasetRefresh'. 2022-09-03T09:06:31.7473045Z ##[debug]Importing function 'New-DataSetSingleRefresh'. 2022-09-03T09:06:31.7493577Z ##[debug]Importing function 'New-PowerBIWorkSpace'. 2022-09-03T09:06:31.7522898Z ##[debug]Importing function 'Publish-PowerBIFile'. 2022-09-03T09:06:31.7542494Z ##[debug]Importing function 'Publish-PowerBIFileApi'. 2022-09-03T09:06:31.7581099Z ##[debug]Importing function 'Publish-TabularEditor'. 2022-09-03T09:06:31.7597466Z ##[debug]Importing function 'Redo-PowerBIReport'. 2022-09-03T09:06:31.7618291Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'. 2022-09-03T09:06:31.7650204Z ##[debug]Importing function 'Remove-PowerBIReport'. 2022-09-03T09:06:31.7671883Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'. 2022-09-03T09:06:31.7731906Z ##[debug]Importing function 'Set-Capacity'. 2022-09-03T09:06:31.7754638Z ##[debug]Importing function 'Set-DatasetOwnersXXX'. 2022-09-03T09:06:31.7784873Z ##[debug]Importing function 'Set-PowerBIDataSetOwnersXXX'. 2022-09-03T09:06:31.7807452Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'. 2022-09-03T09:06:31.7834171Z ##[debug]Importing function 'Set-RefreshSchedule'. 2022-09-03T09:06:31.7854377Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'. 2022-09-03T09:06:31.7875479Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'. 2022-09-03T09:06:31.7899644Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'. 2022-09-03T09:06:31.7921796Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'. 2022-09-03T09:06:31.7981887Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'. 2022-09-03T09:06:31.8003539Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'. 2022-09-03T09:06:31.8023023Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'. 2022-09-03T09:06:31.8059004Z ##[debug]Importing function 'Update-PowerBIDatasetSource'. 2022-09-03T09:06:31.8439086Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '9cf83ac7-2732-4f09-8cde-a98481e56b9e' 2022-09-03T09:06:31.8650985Z ##[debug]ENDPOINT_URL_9cf83ac7-2732-4f09-8cde-a98481e56b9e: 'https://api.powerbi.com/v1.0/myorg' 2022-09-03T09:06:31.8677322Z ##[debug]ENDPOINT_AUTH_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '****' 2022-09-03T09:06:31.8705770Z ##[debug]ENDPOINT_DATA_9cf83ac7-2732-4f09-8cde-a98481e56b9e: '{"OrganizationType":"Public"}' 2022-09-03T09:06:31.8807670Z ##[debug]{ 2022-09-03T09:06:31.8823384Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg", 2022-09-03T09:06:31.8840652Z ##[debug] "Data": { 2022-09-03T09:06:31.8855868Z ##[debug] "OrganizationType": "Public" 2022-09-03T09:06:31.8873058Z ##[debug] }, 2022-09-03T09:06:31.8895021Z ##[debug] "Auth": { 2022-09-03T09:06:31.8912183Z ##[debug] "parameters": { 2022-09-03T09:06:31.8925818Z ##[debug] "TenantId": "xxx", 2022-09-03T09:06:31.8940495Z ##[debug] "ClientId": "", 2022-09-03T09:06:31.9060111Z ##[debug] "ClientSecret": , 2022-09-03T09:06:31.9077336Z ##[debug] "ClientCertificate": "" 2022-09-03T09:06:31.9094734Z ##[debug] }, 2022-09-03T09:06:31.9111707Z ##[debug] "scheme": "None" 2022-09-03T09:06:31.9127493Z ##[debug] } 2022-09-03T09:06:31.9143082Z ##[debug]} 2022-09-03T09:06:32.0686457Z ##[debug]9:06:32 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal. 2022-09-03T09:06:32.0715679Z ##[debug]9:06:32 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:32.1018745Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/xxx 2022-09-03T09:06:32.1882920Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:32.1984771Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(2c2ac929-60f1-4665-b92b-67e52ab31911) 2022-09-03T09:06:32.2089482Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] === AcquireTokenForClientParameters === 2022-09-03T09:06:32.2106338Z ##[debug]SendX5C: False 2022-09-03T09:06:32.2135829Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:32.2168609Z ##[debug]RegionToUse: 2022-09-03T09:06:32.2191309Z ##[debug]ForceRefresh: False 2022-09-03T09:06:32.2206626Z ##[debug] 2022-09-03T09:06:32.2251845Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] 2022-09-03T09:06:32.2279870Z ##[debug]=== Request Data === 2022-09-03T09:06:32.2284065Z ##[debug]Authority Provided? - True 2022-09-03T09:06:32.2301562Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:32.2334413Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:32.2353728Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:32.2462798Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:32.2481205Z ##[debug]SendX5C - False 2022-09-03T09:06:32.2499539Z ##[debug]LoginHint ? False 2022-09-03T09:06:32.2519286Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:32.2543032Z ##[debug]HomeAccountId - False 2022-09-03T09:06:32.2561248Z ##[debug]CorrelationId - 2c2ac929-60f1-4665-b92b-67e52ab31911 2022-09-03T09:06:32.2587478Z ##[debug] 2022-09-03T09:06:32.2616192Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:32.2636576Z ##[debug]
2022-09-03T09:06:32.2650834Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:32.2711979Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Fetching instance discovery from the network from host login.microsoftonline.com. 2022-09-03T09:06:32.5981295Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Resolving authority endpoints... Already resolved? - FALSE 2022-09-03T09:06:32.6043572Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] ScopeSet was missing from the token response, so using developer provided scopes in the result. 2022-09-03T09:06:32.6065257Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Checking client info returned from the server.. 2022-09-03T09:06:32.6087473Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Saving Token Response to cache.. 2022-09-03T09:06:32.6115080Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] ID Token not present in response. 2022-09-03T09:06:32.6138497Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Saving AT in cache and removing overlapping ATs... 2022-09-03T09:06:32.6159195Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:32.6184817Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] Intersecting scope entries count - 0 2022-09-03T09:06:32.6210666Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 2c2ac929-60f1-4665-b92b-67e52ab31911] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:31 +00:00 === 2022-09-03T09:06:32.6237273Z ##[debug]9:06:32 AM - Connect-PowerBIServiceAccount end processing. 2022-09-03T09:06:32.6278347Z ##[debug]INPUTPOWERBIPATH: 'D:\a\r1\a\[PowerBI]XXX\XXX_Monitoring_ACC.pbix' 2022-09-03T09:06:32.6310815Z ##[debug]INPUT_WORKSPACENAME: 'WorkspaceName' 2022-09-03T09:06:32.6349815Z ##[debug]INPUT_OVERWRITE: 'true' 2022-09-03T09:06:32.6392329Z ##[debug] Converted to bool: True 2022-09-03T09:06:32.6416231Z ##[debug]INPUT_CREATE: 'false' 2022-09-03T09:06:32.6437434Z ##[debug] Converted to bool: False 2022-09-03T09:06:32.6468684Z ##[debug]INPUT_ACTION: 'DataRefresh' 2022-09-03T09:06:32.6494710Z ##[debug]INPUT_DATASETNAME: 'XXX_Monitoring_ACC' 2022-09-03T09:06:32.6540869Z ##[debug]INPUT_OLDURL (empty) 2022-09-03T09:06:32.6590122Z ##[debug]INPUT_NEWURL (empty) 2022-09-03T09:06:32.6616252Z ##[debug]INPUT_OLDSERVER (empty) 2022-09-03T09:06:32.6641761Z ##[debug]INPUT_NEWSERVER (empty) 2022-09-03T09:06:32.6661286Z ##[debug]INPUT_OLDDATABASE (empty) 2022-09-03T09:06:32.6683799Z ##[debug]INPUT_GROUPOBJECTIDS (empty) 2022-09-03T09:06:32.6707340Z ##[debug]INPUT_NEWDATABASE (empty) 2022-09-03T09:06:32.6729455Z ##[debug]INPUT_PERMISSION (empty) 2022-09-03T09:06:32.6754302Z ##[debug]INPUT_USERS (empty) 2022-09-03T09:06:32.6777243Z ##[debug]INPUT_DATASOURCETYPE: 'Sql' 2022-09-03T09:06:32.6802611Z ##[debug]INPUT_UPDATEALL: 'false' 2022-09-03T09:06:32.6823472Z ##[debug] Converted to bool: False 2022-09-03T09:06:32.6879057Z ##[debug]INPUT_SKIPREPORT: 'false' 2022-09-03T09:06:32.6895545Z ##[debug] Converted to bool: False 2022-09-03T09:06:32.6919032Z ##[debug]INPUT_INDIVIDUAL (empty) 2022-09-03T09:06:32.6941815Z ##[debug]INPUT_SERVICEPRINCIPALS (empty) 2022-09-03T09:06:32.6963598Z ##[debug]INPUT_CONNECTIONSTRING (empty) 2022-09-03T09:06:32.6985539Z ##[debug]INPUT_PARAMETERINPUT (empty) 2022-09-03T09:06:32.7035717Z ##[debug]INPUT_GATEWAYNAME (empty) 2022-09-03T09:06:32.7058023Z ##[debug]INPUT_REPORTNAME (empty) 2022-09-03T09:06:32.7079701Z ##[debug]INPUT_CAPACITYNAME (empty) 2022-09-03T09:06:32.7131135Z ##[debug]INPUT_USERNAME (empty) 2022-09-03T09:06:32.7155684Z ##[debug]INPUT_PASSWORD (empty) 2022-09-03T09:06:32.7187105Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty) 2022-09-03T09:06:32.7220819Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false' 2022-09-03T09:06:32.7479855Z ##[debug] Converted to bool: False 2022-09-03T09:06:32.7505388Z ##[debug]INPUT_REPORTWORKSPACENAME (empty) 2022-09-03T09:06:32.7563610Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty) 2022-09-03T09:06:32.7909746Z ##[debug]INPUT_PRINCIPALTYPE: 'User' 2022-09-03T09:06:32.7964317Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty) 2022-09-03T09:06:32.7983450Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty) 2022-09-03T09:06:32.8030387Z ##[debug]INPUT_DATASETACCESSRIGHT (empty) 2022-09-03T09:06:32.8112253Z ##[debug]WorkspaceName : WorkspaceName 2022-09-03T09:06:32.8129181Z ##[debug]Create : False 2022-09-03T09:06:32.8146970Z ##[debug]Dataset : XXX_Monitoring_ACC 2022-09-03T09:06:32.8202700Z Trying to refresh Dataset 2022-09-03T09:06:32.8415416Z Getting Power BI Workspace properties; WorkspaceName 2022-09-03T09:06:32.8491736Z ##[debug]9:06:32 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name. 2022-09-03T09:06:32.8533414Z ##[debug]9:06:32 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:32.8696205Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:32.8744569Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(9db10721-f13d-49f7-9f80-87f7b0ebade8) 2022-09-03T09:06:32.8767486Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] === AcquireTokenForClientParameters === 2022-09-03T09:06:32.8781971Z ##[debug]SendX5C: False 2022-09-03T09:06:32.8796796Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:32.8810972Z ##[debug]RegionToUse: 2022-09-03T09:06:32.8825540Z ##[debug]ForceRefresh: False 2022-09-03T09:06:32.8839906Z ##[debug] 2022-09-03T09:06:32.8861388Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] 2022-09-03T09:06:32.8875081Z ##[debug]=== Request Data === 2022-09-03T09:06:32.8890983Z ##[debug]Authority Provided? - True 2022-09-03T09:06:32.8906312Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:32.8920877Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:32.8935177Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:32.8949498Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:32.8988346Z ##[debug]SendX5C - False 2022-09-03T09:06:32.9003299Z ##[debug]LoginHint ? False 2022-09-03T09:06:32.9017275Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:32.9031218Z ##[debug]HomeAccountId - False 2022-09-03T09:06:32.9046884Z ##[debug]CorrelationId - 9db10721-f13d-49f7-9f80-87f7b0ebade8 2022-09-03T09:06:32.9062667Z ##[debug] 2022-09-03T09:06:32.9082742Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:32.9124461Z ##[debug]
2022-09-03T09:06:32.9140973Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:32.9162070Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] Access token is not expired. Returning the found cache entry. [Current time (09/03/2022 09:06:32) - Expiration Time (09/03/2022 10:06:31 +00:00) - Extended Expiration Time (09/03/2022 10:06:31 +00:00)] 2022-09-03T09:06:32.9181140Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:32 - 9db10721-f13d-49f7-9f80-87f7b0ebade8] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:31 +00:00 === 2022-09-03T09:06:33.2822555Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'WorkspaceName'&$top=100 2022-09-03T09:06:33.2878162Z ##[debug]Status Code: OK (200) 2022-09-03T09:06:33.2924831Z ##[debug]9:06:33 AM - Get-PowerBIWorkspace end processing. 2022-09-03T09:06:33.3010018Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]90a2e4bf-7f42-4aaf-826b-8df2c27db93c 2022-09-03T09:06:33.3142910Z ##[debug]9:06:33 AM - Get-PowerBIAccessToken begin processing with ParameterSet AllParameterSets. 2022-09-03T09:06:33.3184294Z ##[debug]9:06:33 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:33.3218760Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:33.3241678Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4bbd9746-e8c4-452a-bb85-b07d5291db30) 2022-09-03T09:06:33.3263237Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] === AcquireTokenForClientParameters === 2022-09-03T09:06:33.3279609Z ##[debug]SendX5C: False 2022-09-03T09:06:33.3303848Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:33.3323665Z ##[debug]RegionToUse: 2022-09-03T09:06:33.3344411Z ##[debug]ForceRefresh: False 2022-09-03T09:06:33.3392526Z ##[debug] 2022-09-03T09:06:33.3413542Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] 2022-09-03T09:06:33.3428929Z ##[debug]=== Request Data === 2022-09-03T09:06:33.3445267Z ##[debug]Authority Provided? - True 2022-09-03T09:06:33.3494075Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:33.3540389Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:33.3619700Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:33.3634746Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:33.3650243Z ##[debug]SendX5C - False 2022-09-03T09:06:33.3666045Z ##[debug]LoginHint ? False 2022-09-03T09:06:33.3681436Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:33.3698283Z ##[debug]HomeAccountId - False 2022-09-03T09:06:33.3716831Z ##[debug]CorrelationId - 4bbd9746-e8c4-452a-bb85-b07d5291db30 2022-09-03T09:06:33.3734757Z ##[debug] 2022-09-03T09:06:33.3760285Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:33.3787908Z ##[debug]
2022-09-03T09:06:33.3803487Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:33.3825503Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] Access token is not expired. Returning the found cache entry. [Current time (09/03/2022 09:06:33) - Expiration Time (09/03/2022 10:06:31 +00:00) - Extended Expiration Time (09/03/2022 10:06:31 +00:00)] 2022-09-03T09:06:33.3844994Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - 4bbd9746-e8c4-452a-bb85-b07d5291db30] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:31 +00:00 === 2022-09-03T09:06:33.3893510Z ##[debug]9:06:33 AM - Get-PowerBIAccessToken end processing. 2022-09-03T09:06:33.3925817Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/90a2e4bf-7f42-4aaf-826b-8df2c27db93c/datasets 2022-09-03T09:06:33.4007024Z ##[debug]GET https://api.powerbi.com/v1.0/myorg/groups/90a2e4bf-7f42-4aaf-826b-8df2c27db93c/datasets with 0-byte payload 2022-09-03T09:06:33.6180369Z ##[debug]received -1-byte response of content type application/json; odata.metadata=minimal; odata.streaming=true 2022-09-03T09:06:33.6353062Z ##[debug]Trying to find dataset 'XXX_Monitoring_ACC' 2022-09-03T09:06:33.6498846Z Processing dataset - XXX_Monitoring_ACC 2022-09-03T09:06:33.6550578Z ##[debug]9:06:33 AM - Get-PowerBIAccessToken begin processing with ParameterSet
AllParameterSets. 2022-09-03T09:06:33.6623800Z ##[debug]9:06:33 AM - Cmdlet version: 1.2.1077.0 2022-09-03T09:06:33.6647850Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33] Found 0 cache accounts and 0 broker accounts 2022-09-03T09:06:33.6668284Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(a8c2ecec-1215-46c5-afe9-0e4c2071742a) 2022-09-03T09:06:33.6758699Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] === AcquireTokenForClientParameters === 2022-09-03T09:06:33.6777949Z ##[debug]SendX5C: False 2022-09-03T09:06:33.6794349Z ##[debug]WithAzureRegion: False 2022-09-03T09:06:33.6811250Z ##[debug]RegionToUse: 2022-09-03T09:06:33.6836202Z ##[debug]ForceRefresh: False 2022-09-03T09:06:33.6851170Z ##[debug] 2022-09-03T09:06:33.6906207Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] 2022-09-03T09:06:33.6922831Z ##[debug]=== Request Data === 2022-09-03T09:06:33.6943865Z ##[debug]Authority Provided? - True 2022-09-03T09:06:33.6982422Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default 2022-09-03T09:06:33.7034469Z ##[debug]Extra Query Params Keys (space separated) - 2022-09-03T09:06:33.7057197Z ##[debug]ApiId - AcquireTokenForClient 2022-09-03T09:06:33.7101683Z ##[debug]IsConfidentialClient - True 2022-09-03T09:06:33.7118188Z ##[debug]SendX5C - False 2022-09-03T09:06:33.7166231Z ##[debug]LoginHint ? False 2022-09-03T09:06:33.7192809Z ##[debug]IsBrokerConfigured - False 2022-09-03T09:06:33.7283681Z ##[debug]HomeAccountId - False 2022-09-03T09:06:33.7316888Z ##[debug]CorrelationId - a8c2ecec-1215-46c5-afe9-0e4c2071742a 2022-09-03T09:06:33.7331993Z ##[debug] 2022-09-03T09:06:33.7364617Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] === Token Acquisition (ClientCredentialRequest) started: 2022-09-03T09:06:33.7382564Z ##[debug]
2022-09-03T09:06:33.7404916Z ##[debug] Authority Host: login.microsoftonline.com 2022-09-03T09:06:33.7428641Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] Access token is not expired. Returning the found cache entry. [Current time (09/03/2022 09:06:33) - Expiration Time (09/03/2022 10:06:31 +00:00) - Extended Expiration Time (09/03/2022 10:06:31 +00:00)] 2022-09-03T09:06:33.7474951Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [09/03/2022 09:06:33 - a8c2ecec-1215-46c5-afe9-0e4c2071742a] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 09/03/2022 10:06:31 +00:00 === 2022-09-03T09:06:33.7482143Z ##[debug]9:06:33 AM - Get-PowerBIAccessToken end processing. 2022-09-03T09:06:33.7506987Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/90a2e4bf-7f42-4aaf-826b-8df2c27db93c/datasets/1ca0314a-eb77-49a3-a0b9-30f63c52f5e5/refreshes 2022-09-03T09:06:33.7560840Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/90a2e4bf-7f42-4aaf-826b-8df2c27db93c/datasets/1ca0314a-eb77-49a3-a0b9-30f63c52f5e5/refreshes with 0-byte payload 2022-09-03T09:06:33.8511586Z ##[debug]received -1-byte response of content type application/octet-stream 2022-09-03T09:06:33.8517296Z 2022-09-03T09:06:33.8523596Z Done processing Power BI Actions 2022-09-03T09:06:33.8524349Z Done running Power BI Actions extension. 2022-09-03T09:06:33.8553421Z ##[debug]Leaving D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1. 2022-09-03T09:06:33.8962486Z ##[section]Finishing: Power BI Action: Refresh dataset

maikvandergaag commented 1 year ago

Yes if you want to use the Username Password option you should use an account that does not require MFA.

Do you also have the required API permissions on the app?

99Wasdqwop commented 1 year ago

Yes, Ive verified the permissions with a colleague as well. And we tested another function such as refreshing the dataset

maikvandergaag commented 1 year ago

Could you perform the actions locally to check if that works with the same creds?

99Wasdqwop commented 1 year ago

What do you mean exactly?

maikvandergaag commented 1 year ago

Extract the specific PowerShell commands from the repo. Ans run them locally.

datasharkNL commented 1 year ago

@maikvandergaag I'm facing the same issue with the Power BI Actions plugin on DevOps

maikvandergaag commented 1 year ago

@datasharkNL could you also include some info and maybe test locally?

maikvandergaag commented 1 year ago

as there is no more response we are closing this issue