Can't update dataset parameter programmatically

Dres — Sun, 11 Oct 2020 19:30:23 GMT

Hi,

we're using the C# SDK (Microsoft.PowerBI.Api.V2) to automate the process of creating new workspaces with a single dataset/report by cloning an existing one (kind of like a template). The datasource is a web endpoint, and it uses a paramter which needs to be upated for the new dataset. Unfortunately that last step returns a forbiden error (operation is only supported for the dataset owner), which makes no sense because the operation is being run under the same account that creates the dataset to begin with. Here are the steps we're taking

Create a new instance of the PowerBIClient class using the app registration accoutn details (works)
Create a new workspace (works)
Get the template dataset and "clone it" into the new workspace. This is done by reading the file and using the PostImportWithFileAsyncInGroup function (works)
Ge the new dataset's name (works)
Use the UpdateParametersAsync function to update the paramter so it points to a different datasource (fails, forbbiden error)

var paramRequest = new UpdateDatasetParametersRequest(new UpdateDatasetParameterDetails("paramName", "paramValue")); await client.Datasets.UpdateParametersAsync(group.Id, newDataset.Name, paramRequest);

Not sure if I'm missing something obvious, but it makes little sense that the account that's creating the dataset in the firstplace, can't update the parameter because of permissions. If I navigate to the PowerBI App and check the new dataset access, it show the app registration as the owner. If I check the dataset settings, some of the options (including the parameters section) are disabled because "This dataset has been configured by AppRegistrationName (App ID: 00000-0000-0000-0000-00000000). Would you like to take over the settings?"

That's a clear indication that the app registration account is indeed the owner of that dataset, which also happens to be the account that runs the whole process, so why would I get a forbidden error??

Any help would be greatly appreciated

Re: Can't update dataset parameter programmatically

lbendlin — Mon, 12 Oct 2020 14:48:04 GMT

A couple weeks back there was a fantastic Power BI Dev Camp that talked about this in great depth.

topic Can't update dataset parameter programmatically in Developer

Can't update dataset parameter programmatically

Re: Can't update dataset parameter programmatically