COMPOSITE DATA MODEL WITH NUMEROUS APIS

[ravjay]

Ok, I'm a new bee and we have issues loading larger data sets to power bi. either APIs are crashing or reaching 'out memory status' or failing when auto-refresh is scheduled.  Hence, we came up with the following composited data model concept..,

steps,

1. create base data models through APIs (some base data models just have a single larger data table - Ex: Purchase order receipts)

2. then using these multiple base data models, a higher-level composite data model will be created. These composite data models obtain data from a power bi data set; base data models. Only at this level, all key measures required for reporting are to be defined.

3. Then refresh scheduled to each base data model at a specific time gap in between - the idea is to reduce the data load obtained through APIs & server when refreshing. 

4. in long run, expand the model by adding similar composite data models to multi companies and provide one consolidated power bi report for the whole company. 

 Tell me how crazy is this idea, any other way to optimize it, all your expert ideas are highly appreciated. 

[v-jayw-msft]

Hi @ravjay ,

Are these datasets under same tenant?

Best Regards,

Jay

[ravjay]

Yes, 

Each dataset represents the individual company (X,Y) under one tenant