Update SQL credential succeed but refresh with error data source is missing credentials

[boleung]

Describe the issue Update SQL credential but it still prompt error that Scheduled refresh is disabled because at least one data source is missing credentials

Extension

• Extension: Power BI Action
• Version: 5.*

To Reproduce Steps to reproduce the behavior:

1. In Pipeline, upload a report
2. Update SQL Credential for the report with a username and password
3. Set refresh scheule as well
4. Run pipeline successfuly
5. Go to the report imported, there is an error sign beside the referesh of the dataset
6. Click the error sign
7. Login Power BI with the username and password set in step 2, click settings of the dataset, it shows the dataset is configured by the service principle
8. Click "Take Over" to take over the dataset
9. Open the dataset, click "Refresh" button, the error disappears

Expected behavior Dataset should be able to refresh with the credential set.

Situation (please complete the following information):

• Agent type: Self-hosted Windows Agent
• Autentication: Service Principle
• Extension Version: 5

Log info

Additional information No.

[maikvandergaag]

The process is not able to find the correct report it seems. Could you add a step to make the spn owner?

[maikvandergaag]

For the next time do not provide a log file with the credentials in it.

[boleung]

Added a step to make the spn owner, but still the same.

Even run it after taking over the dataset with the username of step 2, the credential is missing

[BoLiangBamboo]

Our datasource is dataverse. Reviewed the source code and found it only supports sql credential update but not dataverse.

[maikvandergaag]

That is correct!