Forum Discussion
Power BI On Prem scheduled task error
Hello,
We use Power Bi on Prem - Version 1.4.6960.38798 (January 2019) – We get scheduled error some power bi reports. I used some solution which I found internet but issue still continue . How can we solve this issue?
0] -1055784932: Credentials are required to connect to the SQL source. (Source at server1;database1.). The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[8] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[9] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
Thanks.
murater85 wrote:I have already done it. I open report on Power bi desktop then click refresh everything is ok , it has refreshed after that ı upload on PBRS , create a new scheduled task but gives same error.
No, it does not matter what you do in the Desktop. Any passwords you save there are encrypted using your local user. When you upload a report to the server it runs under a service account. Because it runs under a different account it can't decrypt a password saved by another user. For this reason in order to do a scheduled refresh you need to follow the instructions I posted previously to save the credentials on your server.
5 Replies
Click on the "..." menu when you hover over the report in Power BI Report Server. Choose the "Manage" option and then go into the "Data Sources" tab. If you want to schedule a refresh you will need to enter credentials against your data sources so that the scheduled refresh can authenticate against those data sources.
murater85 wrote:I have already done it. I open report on Power bi desktop then click refresh everything is ok , it has refreshed after that ı upload on PBRS , create a new scheduled task but gives same error.
No, it does not matter what you do in the Desktop. Any passwords you save there are encrypted using your local user. When you upload a report to the server it runs under a service account. Because it runs under a different account it can't decrypt a password saved by another user. For this reason in order to do a scheduled refresh you need to follow the instructions I posted previously to save the credentials on your server.
