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

Automatically create local models based on perspectives in golden dataset.

I have a golden dataset which contains all (most) of the data I use for organizational reporting. Reports are built by connecting to this golden dataset (Power BI and Excel reports). The model is quite large but I would like to be able to build reports combining many different topics so ideally I would like to keep a single (golden) dataset. 


However the model is too large for analists to understand, and also contains many tables that are not applicable to them. This is why I created perspectives which shows subsets of the model. (And don't worry; I'm not using perspectives for security purposes).


Analists connect to the dataset using Excel or Power BI just select the golden dataset which contains everything and they cannot just select a perspective (afaik, I am aware that you could change the connection properties in Excel but that lacks user friendliness). So my idea was to use composite models and create a local model, with a live connection to the golden dataset where the perspective is pre-selected. Publish this dataset to the service, provide access to these datasets to the necessary analist groups and it actually works pretty good. The only issue is that each change in the golden dataset requires me to manually repeat this process because the perspective is not automatically updated, I'm assuming this is because the local model creates a copy of the XMLA code with a connection to the source model and this will not update automatically. 

So basically my question is: is it possible to automate the process of updating the local (perspective) models based on the current status of the perspectives in the golden dataset? Or is there a better way which I'm missing?




@dotykier Any idea on getting this done by using Tabular Editor? 

Super User
Super User

Hi @BasNL 


As far as I am aware there is no other way to do this at the moment.


You can vote for the idea at

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

Proud to be a Super User!

Power BI Blog

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