Data source credentials switching? (Report Server)

[smelei]

We've got a report which has two SQL data sources, both using SQL logins.

The report has begin to experience an issue where scheduled refrsh fails, citing one of the logins failing as the cause.

On going into Data sources for the report, we re-enter the credentials for the specified login, test successfully and save. We also click test on the other login, which wasn't mentioned in the error message.

On the next refresh, there's another failure, citing the other login now.

Experiencing this in 1.2.6690.34729 (Dev environment) and 1.2.6660.39920 (Live environment).

On both environments, there's a daily scheduled restart of the PowerBIReportServer service.

[v-qiuyu-msft]

Hi @smelei,

Except restarting Power BI report server service, is there any other change you made before subscription hit schedule time?

How about the result if you don't restart the Power BI report server service? 

Please keep running the latest Power BI report server version 15.0.2.402. 

Best Regards,
Qiuyun Yu 

[smelei]

Hi @v-qiuyu-msft,

I've tested this issue with the resart in place and before we put the restart in place, with the same outcome.

Kind regards

@smelei

[smelei]

I've found a work-around (not ideal) - do a Save as with a different file name.

Raised with the Support team - they couldn't fing a better solution, so have raised as an issue with the product team.