Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Any options to add fields/measures/tables on a shared dataset?



Company I work for, maintains a few "standard" datasets created by IT to be used company-wide/world-wide.

These are published in a premium capacity and each contains a lot of information and measures on specific subjects, like Sales, Purchases, etc.

Datasets implement row-level security based on AAD.


Power users/content creators can then use these datasets as data sources to create new reports.

User creating a new report in Desktop will only see the report and model views, but not the data view (so limited customization options):



When publishing, power users/content creators only deploy a report (not a dataset).

Adding new fields, transforms and measures is managed/approved centrally, which is sometimes a slow(ish) process ☹️


This model works fine for common reporting needs, but advanced users have been regularly asking for the ability to connect directly to the data warehouse and/or to be able to add their own tables and transforms in Power BI.


This directly conflicts with data security policies, global reporting policies, etc. so far nothing done ☹️

Even if not for company policy, directly downloading the datasets to modify locally then reload would not be possible because of incremental refresh.


Adding a second data source dataset in Desktop with DirectQuery allows publishing both a report and dataset, but data view still cannot be used (and DirectQuery is slow when working with large datasets).


Question is then:

Is there a way in Power BI that allows a user to "somehow" use a shared dataset as data source, add his own calculated fields/measures/tables and then store them in a new dataset?


Probably, its a no to above, but just trying to find a solution that fits everyone here and leave no rock unturned.


Big Thanks 🙂

Super User
Super User



Have you explored composite models? You can create a pbix that uses a shared dataset as the primary data source, and add fields/tables. This composite-model pbix can be published and used as a data source for reports. 

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

Proud to be a Super User!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors