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

Problem with data refresh after update of data source

I have an automated the process of restoring the Power BI Report server database from production environment to development environment. After the restore I update the data sources to reflect the changes required within development environment. This works fine and I can browse to the reports and "Test connection" says "Connected successfully".

However the schedule data refresh fails and shows the original data source as the cause of the error. So it seems that the "data refresh" is using another data source which has not been updated in the process.

The error in the data refresh is "1055784932: Credentials are required to connect to the SQL source. (Source at prod;msdb.). The exception was raised by the IDbCommand interface."

Any idea where this data source is saved and how it can be updated?
Thx
Stefan 

2 REPLIES 2
FarhanAhmed
Super User
Super User

does your automated process also create the automated schedule of the report in PBIRS?

 

Looks like it is failing as soon as it tries to execute the schedule as all of the schedules created in msdb. Delete the schedule and try re-creates one should do the job.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




ssce
Frequent Visitor

Unfortunately I does not make any difference when creating a new schedule.

 

The same error comes up pointing to the production data source instead av the dev data source.

It seems like it is saved in a second place or it is some kind of cache which is not updated.

Any more suggestions?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.