Transfer Dataset including RLS to new Workspace

[Chrispi]

Hi there,

I want to transfer a Dataset to another workspace without losing all the groups in the security settings. I already tried to do it via a pipeline but it seems like the groups are still lost even though the comparison in the pipeline shows that the datasets are equal. 

Is there a way to make this work?

thanks in advance

Christian

[ibarrau · Accepted solution]

Hi. I don't think it's possible to copy the asigned mails or groups to roles. You can move a report with its dataset from one workspace to another using the Power bi rest API. However, that will be like downloading and uploading the pbix of the file. I mean, it will have the exact same report with the roles created, but the assignments for the groups or mails at security settings can't me migrated. You need to do it manually.

Here an example of moving between workspaces using a python library for the pbi rest api: 

https://blog.ladataweb.com.ar/post/697833112208539648/simplepbipython-copiar-pbix-entre-áreas-de

I hope that helps,

[Chrispi]

Hi,

I was afraid that would be the answer. 

Thanks anyway

Chris