Forum Discussion
Combine datasets to a new dataset
Community ChampionSo 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.?
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!
- 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.
v-yuta-msftCommunity Support
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