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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi fxs7576_02 ,

Base on your description, it sounds like you're running into an issue with data source credentials after you update the parameters and try to refresh the dataset. Please check if the service principal hit the following limitations:

In addition, the following link is the one which has the similar problem as yours. Hope its solution can help you solve the problem.

Solved: Dataset refresh error Service principal - Microsoft Fabric Community

Best Regards

fxs7576_02's avatar
fxs7576_02
Helper I
1 year ago

Hi Anonymous ,

 

I don't think the Service Principal is facing those limitations.

 

When I looked at the solution in Solved: Dataset refresh error Service principal - Microsoft Fabric Community thread, they used the endpoint to update the datasource credential for Gateway.

$BounGateway=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.GetBoundGatewayDataSources" -Method GET | ConvertFrom-Json

I'm not yet familiar with gateway connection. Is the above endpoint still relevant if I use a personal cloud connection (i.e. RDS MySQL) as opposed to gateway?