cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
murater85
Frequent Visitor

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.

1 ACCEPTED SOLUTION


@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.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Where would I find or file on-going bugs with Power BI Report Server January 2019? I'm having issues with the scheduled refresh using the import connectivity mode. Refresh works fine locally but they've started failing since upgrading to PBIRS January 2019 from PBIRS August 2018.

d_gosbell
Super User
Super User

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. 

Anonymous
Not applicable

Hello.

 

I have Power BI report with parameterized path to MS Excel data sources, so I can't enter credentials to this data source. Is there any decision for this situation?

Hello Gosbell

 

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.

 

How can we solve this issue is there any other idea?

 

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.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!