Can I connect and manage datasets in Power BI Service workspaces?

[vladmakienko]

Using workspaces in Power BI Service allows interacting between owner and admins, members and contributors. After I downloaded my report to Power BI Service I want that selected users in the workspace can modify datasets. Is it possible? Can I also see the relationships between tables in Service? Or is it only in Desktop possible? Thanks in advance!

[vladmakienko]

Using workspaces in Power BI Service allows interacting between owner and admins, members and contributors. After I downloaded my report to Power BI Service I want that selected users in the workspace can modify datasets. Is it possible? Can I also see the relationships between tables in Service? Or is it only in Desktop possible? Thanks in advance!

[v-frfei-msft]

Hi @vladmakienko,

You can only edit your workspace to make the users can edit Power BI content in it or not, you can refer to the picture as below. However, you cannot select specific users in the workspace that can modify datasets. For your second question, currently we can only see the relationships between tables in Power BI desktop. You can download the report and open the pbix in Power BI desktop to view the relationships.

Regards,

Frank

[vladmakienko]

Hey Frank!

Thanks for your answer! Are you sure that users in workspaces can't modify datasets? What's the sense of creating workspaces if my colleges can't modify/merge datasets? How can I implement the central reporting in my company? So selected users have access to selected data sources and data sets..

I really need help in this question! 

Thanks in advance 

Regards

[v-frfei-msft · Accepted solution]

Hi @vladmakienko,

They cannot merge / append tables in power bi service. So that means that they cannot edit the datset in Power Bi service. However the users can edit the reports of the dataset and save it by themselves. One way to work around is downloading the pbix of the report and republish it.

Regards,

Frank

[vladmakienko]

Hey Frank! Thanks for your answer. It's really helpful! You say it is possible to make the contributors and members of my workspace to be able to modify the content, right? Datasets are the part of this content. But why they can't modify the datasets? I want the members of my workspace can work on their own. Can they download the content (report or dataset) to their desktop and after modifications send it back to the Service? It would be nice if they could for example merge the original dataset with some others or something like that... Are there other possibilities to implement this idea? @v-frfei-msft

[v-frfei-msft]

Hi @vladmakienko,

Users can download the report as pbix and open the pbix in Power BI desktop and edit it. after that they can republish the report to service.

Regards,

Frank

[v-frfei-msft]

Hi @vladmakienko,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[nirvana_moksh]

True data manipulation and transformation is done on the Desktop level only, same goes for the relationship. The new previewed workspace allows memeber's to have to edit permission to the report, but that is to change the report visuals and things around those lines. True data transformations need to be pushed from the Desktop after they are done there using M or DAX etc.