Forum Discussion

JorisVoorn's avatar
JorisVoorn
Microsoft Employee
5 years ago
Solved

Data Set Takeover Not Available - Scheduled Refresh disabled

Dear team,   I am not able to take over one of our datasets in workspace that I manage.   This is currently preventing us from setting up scheduled refresh.   Problem seems to be related to the...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  JorisVoorn ,
    The user who created the dataset and configured the scheduled refresh for the dataset no longer exists. To successfully run the report and schedule the refresh, you need to take over the settings.

     

    You can find the workspace in the admin portal, add yourself as the admin of this workspace, and become the owner of this workspace so that you can use this dataset.

    1. Admin portal – Workspaces, find the workspace and select Recover.

    2. Enter the email, you can add it as admin.

    https://dataveld.com/2019/01/31/what-is-an-orphaned-workspace-in-power-bi/

     

    You could use the PowerShell script below to take over the dataset in the Power BI Service.

    This will allow you to keep everything as is, but change the Owner. 

    https://github.com/Azure-Samples/powerbi-powershell/blob/master/takeover-dataset.ps1

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.