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
Anonymous
Not applicable

Data Governance and Calculated Columns + Measures

I'm trying to understand the best strategy to employ around allowing developers to use a data set I publish in PowerBI while maintaining consistent data definitions accross my business.

 

In particular, I want to allow these developers to build reports with my data set, but I want to restrict them from creating their own calculated columns and measures. The thinking here is that I want to ensure that different developers aren't using their own definitions for the same calculations or groupings. I'd like to provide such calculations in the dataset itself and a set of measures that I can create and allow them to use.

 

What is the best way to go about this? Thanks!

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @Anonymous


As far as I know, Power BI launched last year "direct query for power bi datasets" function can be more perfect to suit your needs, you can write measures and calculated columns in the data model in advance, when developers use DQ connection mode to connect to your generated dataset, they only have use and read-only permissions for your measures and calculated columns, but do not have permission to modify again. They can develop their own reports by creating visuals with existing table models and measure aggregations, and after publishing to the service, the reports are also connected to your dataset.

For the prerequisites and some limitations of this function, you can refer to this document for details:

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

 

View solution in original post

3 REPLIES 3
v-yueyunzh-msft
Community Support
Community Support

Hi , @Anonymous


As far as I know, Power BI launched last year "direct query for power bi datasets" function can be more perfect to suit your needs, you can write measures and calculated columns in the data model in advance, when developers use DQ connection mode to connect to your generated dataset, they only have use and read-only permissions for your measures and calculated columns, but do not have permission to modify again. They can develop their own reports by creating visuals with existing table models and measure aggregations, and after publishing to the service, the reports are also connected to your dataset.

For the prerequisites and some limitations of this function, you can refer to this document for details:

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

 

Tutu_in_YYC
Resident Rockstar
Resident Rockstar

Hi Jamodio,
The prevent them from creating further calculations, you would need to set the permission to the dataset to Read only.

Tutu_in_YYC_1-1669068111258.png

If you give more than read, theres a possibility the developer can create more datasets (adding columns/tables/measures) based on your original dataset, this is called "Chaining"

For you to update more calculations or measuresm you can use ALM Toolkit to just publish the calculations.
http://alm-toolkit.com/


 

GilbertQ
Super User
Super User

Hi @Anonymous 

 

What you could do is to allow the users to create Power BI Reports in the Power BI Service?

 

This will allow them to get read-only access to the datasets. They will be able to use all the fields and measures, but not be able to create any new measures or calculated columns.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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