Combine datasets to a new dataset

[Anonymous]

Hello,

We have a standard layout for a data model that is managed at each our accounts' levels.  Those accounts often modify, for example, logic in calculated measures. We want to "roll up" across those account into single data set so we can provide an enterprise view that incorporates those account-specific logic tweaks.

I read some posts where it was suggested to create new dataset with a new query from the source db tables, but we need to incorporate the logic overrides at the dataset level.

Is this possible?  

Thanks.

[Greg_Deckler]

So you have multiple PBIX files that are published to the Service and those datasets are what you are trying to roll-up, is that correct? And you want all of the Measures, calculated columns, etc.?

[Anonymous]

Exactly.  Let's say I have 3 accounts I want to get to where I can have the "Enterprise Data Set" that incorporates the data and DAX logic of common fields from the underlying DataSets because they use the same table/column names.

Order_Table1---------------------->

Customer_Table1------------------>  DataSet1------------------------>

Shipment_Table1------------------>

Order_Table2---------------------->

Customer_Table2------------------>  DataSet2------------------------>        EnterpriseDataSet ----------> Report

Shipment_Table2------------------>

Order_Table3---------------------->

Customer_Table3------------------>  DataSet3------------------------>

Shipment_Table3------------------>

Thanks!

[v-yuta-msft]

Hi npsmith,

So your requirement is something like summarizing reports?  If it is, have you tried app workspace or new app workspace in power bi service? You can publish different  report and dataset into one workspace and publish as an app.

Regards,

Jimmy Tao

[Greg_Deckler]

My personal opinion on this is that you are surpassing pure Power BI with this desire and you should move towards SSAS or Azure Analysis Services. If you convert your datasets to tabular cubes in SSAS or AAS (they are already tabular cubes) then you could accomplish what you are going for. 

Even with Composite Models, once you connect Live to a Power BI Dataset that's it.