Forum Discussion

fxs7576_02's avatar
fxs7576_02
Helper I
1 year ago

Problem with Refreshing Dataset after Parameter Change with Service Principal

Hi PowerBI Community,   I have a few semantic models (sourced from AWS/GCS and not via. Gateway) that are not owned by Service Principal. My goal is to programmatically change some parameters that ...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

I would recommend you raise a DCR.

fxs7576_02's avatar
fxs7576_02
Helper I
11 months ago

Hey LJonesStripe and jbauti10 , apology for the super late response on this.

 

I managed to find the solution to this using the following process:

  1. Create a gateway, and save its gateway_id.
  2. Take over the dataset from the original user to Service Principal. The Service Principal must the dataset owner to update the parameter. (POST endpoint) 
  3. Update the parameter of the dataset (POST endpoint)
  4. Get the data source from the dataset, and retrieve its [gatewayId] (GET endpoint)
  5. If the gateway_id from step #1 is not the same as that from step #4, run this POST endpoint to bind the gateway. <--- For some reason this is required. Not sure why yet.
  6. Refresh the dataset to apply the parameter change to the dataset. (POST endpoint)

Let me know if it works on your end.