Power BI Action: Update Datasource Connection (Operation is not supported for selector #4)

Question

Hi,&nbsp;&nbsp;I am trying to setup Power BI CICD in Azure DevOps. I am using Power BI Action to publish report and update datasource connection.I am able to update datasource connection for the first datasource after thaT THIS ERROR COMES WHEN i TRY TO UPDATE FOR THE OTHER DATASETS.All the datasets are from same server and database.&nbsp;2020-04-12T01:34:19.8820835Z ##[section]Starting: Power BI Action: UpdateDatasource2020-04-12T01:34:19.8914968Z ==============================================================================2020-04-12T01:34:19.8915447Z Task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Power BI Actions2020-04-12T01:34:19.8915838Z Description&nbsp; : Release Task Power BI Actions2020-04-12T01:34:19.8916195Z Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 4.0.92020-04-12T01:34:19.8916376Z Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Maik van der Gaag2020-04-12T01:34:19.8916553Z Help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:19.8916785Z ==============================================================================2020-04-12T01:34:20.6617949Z ******************************2020-04-12T01:34:20.6625224Z ** Service Connection: &lt;name&gt;2020-04-12T01:34:20.6632505Z ** TenantId: ***2020-04-12T01:34:20.6636813Z ** ClientId: ***2020-04-12T01:34:20.6642299Z ******************************2020-04-12T01:34:20.7485274Z FilePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : D:\a\r1\a2020-04-12T01:34:20.7488970Z ClientID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;: ***2020-04-12T01:34:20.7522957Z PassWord&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;: &lt;not present&gt;2020-04-12T01:34:20.7525953Z Username&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;:2020-04-12T01:34:20.7529197Z WorkspaceName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;workspacename&gt;2020-04-12T01:34:20.7532405Z Overwrite&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : True2020-04-12T01:34:20.7535433Z Create&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : True2020-04-12T01:34:20.7538503Z Action&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : UpdateDatasource2020-04-12T01:34:20.7541587Z Dataset&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;datasource name&gt;2020-04-12T01:34:20.7544434Z Users&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:20.7547399Z AccessRight&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:20.7550362Z OldServer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;name&gt;.database.windows.net2020-04-12T01:34:20.7553267Z NewServer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;name&gt;.database.windows.net2020-04-12T01:34:20.7556159Z OldDatabase&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;name&gt;-dev2020-04-12T01:34:20.7559020Z NewDatabase&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &lt;name&gt;-tst2020-04-12T01:34:20.7561882Z OldUrl&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:20.7565337Z NewUrl&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:20.7568496Z DatasourceType&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Sql2020-04-12T01:34:20.7572075Z UpdateAll&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : False2020-04-12T01:34:20.7584450Z ClientSecret&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : System.Security.SecureString2020-04-12T01:34:20.7588361Z TenantId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : ***2020-04-12T01:34:20.7591275Z Service Principals&nbsp;&nbsp;&nbsp; :2020-04-12T01:34:20.7610332Z Logging in with a Service Principal2020-04-12T01:34:21.5151681Z Trying to update the datasource2020-04-12T01:34:21.5301283Z Getting Power BI Workspace properties; &lt;workspacename&gt;2020-04-12T01:34:23.5655273Z ##[error]Operation is not supported for selector #42020-04-12T01:34:23.6131640Z ##[section]Finishing: Power BI Action: UpdateDatasource

jayendran · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Please see the below answer which might help you
&nbsp;
https://community.powerbi.com/t5/Developer/quot-Operation-is-not-supported-for-selector-quot-when-using/td-p/372441

anonymous · Answer

I was using the following PowerShell script to update data source connection.&nbsp;$datasetname="Dashboard Dataset"$workspacename="REPORT_TEST"&nbsp;$clientsec = "$(client_secret)" | ConvertTo-SecureString -AsPlainText -Force&nbsp;$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $env:client_id, $clientsecConnect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $env:tenant_id&nbsp;$workspace =Get-PowerBIWorkspace -Name $workspacename&nbsp;$DatasetResponse=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets" -Method Get | ConvertFrom-Json&nbsp;&nbsp;$datasets = $DatasetResponse.value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach($dataset in $datasets){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if($dataset.name -eq $datasetname){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $datasetid= $dataset.id;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; $postParams = @{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;updateDetails =@(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name="database"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;newValue="db-test"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name="server"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;newValue="server-test"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )} | ConvertTo-Json&nbsp;Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.TakeOver" -Method Post&nbsp;$response=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.UpdateParameters" -Method Post -Body $postParams | ConvertFrom-Json&nbsp;And its giving error2020-04-13T23:33:46.3600483Z&nbsp;##[section]Starting:&nbsp;Update&nbsp;parameters&nbsp;for&nbsp;dataset2020-04-13T23:33:46.3816028Z&nbsp;==============================================================================2020-04-13T23:33:46.3816393Z&nbsp;Task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;PowerShell2020-04-13T23:33:46.3816710Z&nbsp;Description&nbsp;&nbsp;:&nbsp;Run&nbsp;a&nbsp;PowerShell&nbsp;script&nbsp;on&nbsp;Linux,&nbsp;macOS,&nbsp;or&nbsp;Windows2020-04-13T23:33:46.3817021Z&nbsp;Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;2.165.02020-04-13T23:33:46.3817293Z&nbsp;Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;Microsoft&nbsp;Corporation2020-04-13T23:33:46.3817666Z&nbsp;Help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;https://docs.microsoft.com/azure/devops/pipelines/tasks/utility/powershell2020-04-13T23:33:46.3818127Z&nbsp;==============================================================================2020-04-13T23:33:47.1929102Z&nbsp;Generating&nbsp;script.2020-04-13T23:33:47.2347065Z&nbsp;==========================&nbsp;Starting&nbsp;Command&nbsp;Output&nbsp;===========================2020-04-13T23:33:47.2609972Z&nbsp;##[command]"C:\windows\System32\WindowsPowerShell\v1.0\powershell.exe"&nbsp;-NoLogo&nbsp;-NoProfile&nbsp;-NonInteractive&nbsp;-ExecutionPolicy&nbsp;Unrestricted&nbsp;-Command&nbsp;".&nbsp;'D:\a\_temp\236958ca-ebd7-43a5-8876-a6505f0a70ea.ps1'"2020-04-13T23:33:49.0798312Z&nbsp;2020-04-13T23:33:49.0799535Z&nbsp;2020-04-13T23:33:49.0802661Z&nbsp;Environment&nbsp;:&nbsp;Public2020-04-13T23:33:49.0803552Z&nbsp;TenantId&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;2020-04-13T23:33:49.0804332Z&nbsp;ClientId&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;***2020-04-13T23:33:49.0804530Z&nbsp;Password&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;********2020-04-13T23:33:49.0804683Z&nbsp;2020-04-13T23:33:50.0959876Z&nbsp;WARNING:&nbsp;The&nbsp;Body&nbsp;parameter&nbsp;was&nbsp;null,&nbsp;the&nbsp;request&nbsp;may&nbsp;be&nbsp;invalid&nbsp;when&nbsp;Method&nbsp;parameter&nbsp;is&nbsp;Post.2020-04-13T23:33:50.4406494Z&nbsp;2020-04-13T23:33:51.1154649Z&nbsp;Invoke-PowerBIRestMethod&nbsp;:&nbsp;One&nbsp;or&nbsp;more&nbsp;errors&nbsp;occurred.2020-04-13T23:33:51.1155801Z&nbsp;At&nbsp;D:\a\_temp\236958ca-ebd7-43a5-8876-a6505f0a70ea.ps1:37&nbsp;char:112020-04-13T23:33:51.1156390Z&nbsp;+&nbsp;$response=Invoke-PowerBIRestMethod&nbsp;-Url&nbsp;"groups/$($workspace.id)/data&nbsp;...2020-04-13T23:33:51.1156920Z&nbsp;+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2020-04-13T23:33:51.1157537Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;CategoryInfo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;WriteError:&nbsp;(Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod)&nbsp;[Invoke-PowerBIR&nbsp;2020-04-13T23:33:51.1158077Z&nbsp;&nbsp;&nbsp;&nbsp;estMethod],&nbsp;AggregateException2020-04-13T23:33:51.1158601Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;FullyQualifiedErrorId&nbsp;:&nbsp;One&nbsp;or&nbsp;more&nbsp;errors&nbsp;occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod2020-04-13T23:33:51.1159039Z&nbsp;&nbsp;2020-04-13T23:33:51.1505339Z&nbsp;2020-04-13T23:33:51.1505696Z&nbsp;2020-04-13T23:33:51.1984740Z&nbsp;##[section]Finishing:&nbsp;Update&nbsp;parameters&nbsp;for&nbsp;dataset

Forum Discussion

Power BI Action: Update Datasource Connection (Operation is not supported for selector #4)

2 Replies

Related content

Connect to Denodo as datasource with PBIRS

DataSource Error in ODBC Connection

SQL Operator with multiple destinations

Extract List Power BI DataSources/Connections and Reports they are attached to

DataSource not found