topic Is it possible to create a report in my workspace from a dataset that's in another Workspace in Developer

Is it possible to create a report in my workspace from a dataset that's in another Workspace

anon-dev — Wed, 30 Mar 2022 13:14:15 GMT

Hi,

Currently, I'm using the Power BI embed js client in a SPA, and I'm storing datasets in a dedicated workspace because they're shared, but I don't want the reports created from the JS client to be in the same workspace as the datasets, so I figured out that the best place to place them is in my user's My Workspace, as I would have direct control over my reports even if the datasets are shared, while on the other hand dedicating a whole workspace just for me is unnecessary when we have My Workspace, I don't want to reinvent the wheel.

So I know that I can move the reports at will using the REST API to accomplish this, but it doesn't look like a clean approach to me. So I was wondering if there is any way to tell the JS embed client to create my new report in My Workspace instead of the same workspace where the Dataset is?

PD. I know that I can specify another target workspace, but the JS Client won't let me specify to use My Workspace instead.

Re: Is it possible to create a report in my workspace from a dataset that's in another Workspace

Anonymous — Mon, 04 Apr 2022 03:55:47 GMT

Hi @anon-dev ,

According to your statement, I know that you want to create a report in My Workspace by the dataset from another workspace.

There are some prerequisites.

1. The workspace the dataset in should not be a classic workspace.

2. You should have build permission of the dataset. In Power BI, dataset creators can control who has access to their data by using the Build permission.

Then you can create a report by the dataset from another workspace.

Click on New —— Report

Pick a published dataset.

This is a shared dataset in other's new workspace in my organizaition.

For more details you may refer to the offical blogs.

For reference:

Share access to a dataset (preview)

Intro to datasets across workspaces

Best Regards,
Rico Zhou

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