Redirecting existing .pbix to Power BI Service live connection

[pimsbi]

Hello

I am trying to leverage new Power BI Service Live connection function in Power BI Desktop.

I am hoping this feature can facilitate the development and sharing of set of report pages to different groups of users.

I had developed a .pbix containing both dataset and a certain number of report pages.

Now I would like to segment this big .pbix in different set of reports each one to be dedicated to a specific audience according to the following strategy:

- Publish the "core" of the .pbix including The Dataset and a set of general reports

- make copies of the orginial .pbix, keep only the pages for a subset of users, delete rest of the pages, publish

- then assign these reports to different groups

In doing this I got in trouble when cleaning up my .pbix copies as I need to "redirect" such copies to the already published dataset if I want to avoid creating multiple dataset on the Power BI service side.

Is there any way to do this? i.e. to get rid of the tables defined in the .pbix and redirect graphics to the Power BI Service Live connection?

Or simply this is not the strategy I should follow and there is an alternative still allowing not to redraw the report pages?

Thanks in advance

[v-haibl-msft]

@pimsbi

We cannot change the data source of the copied PBIX file to Power BI Service dataset. You can create an idea in https://ideas.powerbi.com for feature request.

According to your demand, you can publish the complete report to Power BI Service. Then edit the complete report in Power BI Service (e.g. remove the unnecessary visuals), and save the updated report as a new one. Now you have two reports with same dataset.

Best Regards,
Herbert

[pimsbi]

Herbert, understood. thank you for your suggestion.

I was able to create more reports based on the same dataset under the same App Workspace.

However I don't see how to distribute different reports to different group of users.

I understand I should use multiple App Workspaces to be assigned to different users, each time publishing my .pbix file to an App workspace and then deleting the pages not meaningful for the specific audience of that workspace.

Sounds quite complicated.

Best regards