Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
We are currently encountering a situation that the dataset cannot be refreshed when it is owned by Service Principal. When we try to click "Refresh", it gives the message:
Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Also, due to the owner of the dataset is Service Principal, the UI of dataset setting is greyed out, the credentials cannot be edited here.
So we are trying to use REST API to update the datasource credentials. We are following the document shared by @Jayendran. Everything works well until the last step of Updating credentials.
Summary of our situation:
$UpdateUserCredential = @{
credentialType = "Anonymous"
credentials = "{`"credentialData`":`"`"}"
encryptedConnection = "Encrypted"
encryptionAlgorithm = "None"
privacyLevel = "Organizational"
skipTestConnection = "True"
} | ConvertTo-Json
Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.value.gatewayId)/datasources/$($BounGateway.value.id)" -Method PATCH -Body $UpdateUserCredential | ConvertFrom-Json
This issue has made our progress keep pending. Can anyone share how it can be solved? Thank you so much!
Houghs
What's your rationale for making the service principal the dataset owner?
Hi lbendlin,
We are using service principal for embedded (app owns data) as we have several workspaces to manage.