cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamodio
New Member

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 , @jamodio


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 , @jamodio


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
Super User
Super User

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 @jamodio 

 

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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors