Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to 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
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
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
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
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
Hi @vladmakienko,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
35 | |
30 | |
14 | |
12 |