Hi there,
As there is no way to stop people uploading data to Power BI via "My Workspace", we've got a need to audit and actively clear out the personal workspaces of our users regularly. This is in addition to education and other fun governance things, but we're a large org and need to put multiple things in place to satisfy our security peeps. They're a bit aghast that thousands of report consumers with free licenses can just click a button and upload anything they like, and I dont blame them as it is a governance nightmare.
I've figured out the audit side and we've now got PBI reports running against the REST APIs that list all reports/datasets/etc. that people have uploaded to "My Workspace". The tricky thing now is to delete them, and here I've hit a problem: It looks like the REST API can't actually do anything to a users Personal Workspace (what the service calls My Workspace).
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/deletedataset - Gives a 404 as it can't see the dataset (as it's not in My "My workspace" but someone elses "My Workspace")
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/deletedatasetingroup - Gives 401 no authorization, which is fun because I'm a tenant admin. This also gives a 401 against my own "My Workspace", but works fine against a modern workspace, so it looks like it's an old O365 group vs Modern Workspace issue.
These have also been tried with a service principal that has been given the ReadWrite.All permissions and the permissions in the Power BI Tenant pages. Nothing works.
Has anyone had luck clearing out peoples Personal Workspaces?
Thanks.
