search

maikvandergaag / msft-extensions

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

UpdateDataSource failed for SQL datasource #419

Closed mschahal closed 1 year ago

mschahal commented 1 year ago

@maikvandergaag

When updating the data source using sql source it fails as invalid request.

image

Steps are as follows:

image

Error:

2022-07-13T01:07:14.8543501Z ##[debug] Authority Host: login.microsoftonline.com 2022-07-13T01:07:14.8563216Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.22000.0 [07/13/2022 01:07:14 - 044be0a5-fd77-4b37-8304-2af6859df646] Access token is not expired. Returning the found cache entry. [Current time (07/13/2022 01:07:14) - Expiration Time (07/13/2022 02:07:13 +00:00) - Extended Expiration Time (07/13/2022 02:07:13 +00:00)] 2022-07-13T01:07:14.8804681Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.22000.0 [07/13/2022 01:07:14 - 044be0a5-fd77-4b37-8304-2af6859df646] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 07/13/2022 02:07:13 +00:00 === 2022-07-13T01:07:14.8824566Z ##[debug]1:07:14 AM - Get-PowerBIAccessToken end processing. 2022-07-13T01:07:14.8843527Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/6fa067b3-9oc3-457e-a268-0553a01e7133/datasets/fd4d2799-33c2-4800-9016-7bcf548d0sr4/Default.UpdateDatasources 2022-07-13T01:07:14.8882453Z ##[debug]POST with -1-byte payload 2022-07-13T01:07:15.4395249Z Done processing Power BI Actions 2022-07-13T01:07:15.4425159Z ##[debug]Caught exception from task script. 2022-07-13T01:07:15.4452885Z ##[debug]Error record: 2022-07-13T01:07:15.5116271Z ##[debug]Invoke-API : InvalidRequest 2022-07-13T01:07:15.5129482Z ##[debug]At C:\BuildAgent\DEV\WorkingFolders\WF_1_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.38\ps_modules\PowerBI\PowerBI.psm1:484 char:9 2022-07-13T01:07:15.5142070Z ##[debug]+ Invoke-API -Url $url -Method "Post" -Body $body -ContentType ... 2022-07-13T01:07:15.5154823Z ##[debug]+ ~~~~~~~~~~~~~ 2022-07-13T01:07:15.5167381Z ##[debug] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException 2022-07-13T01:07:15.5179096Z ##[debug] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-API 2022-07-13T01:07:15.5190844Z ##[debug] 2022-07-13T01:07:15.5210438Z ##[debug]Script stack trace: 2022-07-13T01:07:15.5243348Z ##[debug]at Invoke-API, C:\BuildAgent\DEV\WorkingFolders\WF_1_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.38\ps_modules\PowerBI\PowerBI.psm1: line 307 2022-07-13T01:07:15.5254979Z ##[debug]at Update-PowerBIDatasetDatasource, C:\BuildAgent\DEV\WorkingFolders\WF_1_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.38\ps_modules\PowerBI\PowerBI.psm1: line 484 2022-07-13T01:07:15.5266732Z ##[debug]at Update-PowerBIDatasetDatasources, C:\BuildAgent\DEV\WorkingFolders\WF_1_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.38\ps_modules\PowerBI\PowerBI.psm1: line 414 2022-07-13T01:07:15.5278484Z ##[debug]at , C:\BuildAgent\DEV\WorkingFolders\WF_1_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.38\run.ps1: line 178 2022-07-13T01:07:15.5290096Z ##[debug]at , : line 1 2022-07-13T01:07:15.5302307Z ##[debug]at , : line 22 2022-07-13T01:07:15.5314551Z ##[debug]at , : line 18 2022-07-13T01:07:15.5326045Z ##[debug]at , : line 1 2022-07-13T01:07:15.5345124Z ##[debug]Exception: 2022-07-13T01:07:15.5382550Z ##[debug]Microsoft.PowerShell.Commands.WriteErrorException: InvalidRequest 2022-07-13T01:07:15.5584547Z ##[error]InvalidRequest 2022-07-13T01:07:15.5591993Z ##[debug]Processed: ##vso[task.logissue type=error]InvalidRequest 2022-07-13T01:07:15.5593428Z ##[debug]Processed: ##vso[task.complete result=Failed] 2022-07-13T01:07:15.6003215Z ##[section]Finishing: Power BI Action: UpdateDatasource