Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
corbusier
Advocate IV
Advocate IV

Dataset security and Power BI Live feature

As I understand it, the new feature to allow a new report to use an existing dataset (Power BI Live) is meant to allow one dataset and it's associated measures to be used in new reports. 

 

However, I'm running into a problem with this and don't know if I'm missing something obvious. 

 

The workspace that I've published the reports to is a View-only workspace, since I don't want members editing other reports. They should be, however, free to take a dataset and build a report based off of it. 

 

As of right now, users can not see the Datasets in the workspace when they use the Power BI Live feature, whereas I can, and I can also publish the new report to the workspace. When I send a pbix file from this new report to someone else, they can't open it since it says they don't have permission.

 

What I would like is that a member is able to build a new report, but can't change an existing report unless they've published it in the first place. Is this possible? Second question - can certain members be given Edit access to a View-only workspace, but not Admin?

1 ACCEPTED SOLUTION

@corbusier In order to use the Power BI Live connection, the end user must have edit rights on the dataset.

 

What I would like is that a member is able to build a new report, but can't change an existing report unless they've published it in the first place. Is this possible?

No - permissions are granted on the workspace level, not the dataset/report level.

 

Second question - can certain members be given Edit access to a View-only workspace, but not Admin? Same as above, Not currently. Edit is all or nothing on the workspace for all members.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

@corbusier In order to use the Power BI Live connection, the end user must have edit rights on the dataset.

 

What I would like is that a member is able to build a new report, but can't change an existing report unless they've published it in the first place. Is this possible?

No - permissions are granted on the workspace level, not the dataset/report level.

 

Second question - can certain members be given Edit access to a View-only workspace, but not Admin? Same as above, Not currently. Edit is all or nothing on the workspace for all members.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thanks for the reply, @Seth_C_Bauer. The answer is not what I wanted to hear, but that's better addressed on the Ideas page.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors