Cannot delete dataset because of report outside of the workspace

[Anonymous]

Hi,

I run into a problem. One of our free users (lets call him Mark) has managed to create a report in his personal workspace using a dataset from another workspace. I'm trying to remove the Dataset from a workspace but it gives me a message:

Can't delete this dataset

At least one report outside of your workspace is using this dataset. To see dependent reports, open the Related content pane.

And in Related content when you highlight a report it says:

Workspace: My workspace of Mark@example.com

 Mark is only a Free User, he shouldn't be even able to do that (unless he used a trial version that we turned off for the business now) and I'm an Admin.

How can I remove the dataset without asking Mark to remove the report from his workspace or having to hack Marks account?

Regards,

Jarek

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, The Delete Dataset API can archieve your requirement, please be very careful using delete dataset API. 

We create a dataset, shared with other account, then create report based on this dataset using another account, it can not delete from Web.

Then we get Dateset ID from Settings - Datasets - URL

Try the REST API, just login in and entry the dataset ID

After Run it, the dataset can be deleted. Pleasa be very careful if you want to remove dataset, it is dangerous because you will loss your data in this dataset.

Finally the dataset is disappear.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks,

That worked.

Although I had to use the different API as the dataset wasn't published in my workspace.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/deletedatasetingroup

Thanks,

Jarek

[GilbertQ]

Hi there

I would have a look at the Power BI Admin APIs and see if that can work for you?

https://docs.microsoft.com/en-us/rest/api/power-bi/admin