How to change the owner of a scheduled report?

[dancarr22]

Hello,

We have multiple scheduled reports which have suddenly stopped working.  i.e. Stopped sending out the emails with reports.  The underlying reports work fine - don't time out or anything - they run as normal. 
If we recreate the scheduled reports as a different user they seem to work.  Though, strangely, the owner of the original scheduled report had no change in permissions.

Two questions: (1) Any idea why a scheduled report would suddenly stop working?  There end date is way in the future - 2038 - so hasn't expired.  (2) Is there a way to change the owner of an existing scheduled report?

Thanks,

Dan

[collinq]

Hi @dancarr22 ,

To change the owner of the report in the Service, just go to the semantic model settings and select "take over" (with the userid of the person that is to be the new owner).

A scheduled report might stop if the userid is deleted/removed from the system.  Or, if it was taken over by somebody else and/or the current userid no longer has access (like if it is deleted or removed) then the old version will stop.  The best way to keep everything running is BEFORE person A leaves the organization person B will take over.  That rarely happens of course.  So, in the meantime, everything that person A owned now has to be taken over by person B AND person B needs to have all the access and rights that person A had.  This includes gateway and data source permissions WITHIN Power BI in addition to the permissions to the data in the data source.

[dancarr22]

Thanks @collinq - appreciate your response.  
The scheduled reports are already not the same owner as the underlying dataset.  So, even if we change ownership of the underlying dataset - the scheduled report still retains the same user.  Any other thoughts of how we can go into edit mode of scheduled report and change owner?  Otherwise, we've been recreating each scheduled report manually - which is do-able - just a pain.

Thanks again for your help,

Dan

[collinq · Accepted solution]

Hey @dancarr22 ,

Well, according to this link: Managing Power BI subscriptions just got easier | Microsoft Power BI Blog | Microsoft Power BI  you should be able to find it and select "take over".  But, I am unable to recreate this on my site.  There could be many reasons why I can't do that but please let me know if this works for you.

[dancarr22]

Thanks @collinq that worked!  A very helpful little button!