Set dataset credentials for cloud based datasource

[stefanik]

Hi,

i have this scenario:

1) i have a report with two types of datasources: SQLServer and a BlankQuery against ApplicationInsights DB

2) the report has some parametrs

3) i have a properly configured Service Principal

4) with a combination of cmdlets and powerbi APIs, i'm able to publish to the service, change parameters and set schedule times for 1)

5) the published dataset has the service principal as owner 

Without any other "action", scheduled refresh Fails due to the missing credentials on datasource: is there any way to set dataset credentials for cloud based datasources owned by service principal?

I don't have any gateway.

Thx

[v-deddai1-msft · Accepted solution]

Hi @stefanik ,

Would you please refer to the similar post: https://community.powerbi.com/t5/Service/Dataset-refresh-error-Service-principal/td-p/1078969 ?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[GilbertQ]

Hi there

As far as I know I do not think that the Service Principal is able to modify datasource credentials.

You might have to create a user account to modify the datasource credentials.