Composite Data Model - Advice

[davidv85]

Hi All 

i need to create a report which pulls in a cobmination actual values and forecast values - the actuals value wont change but the forecast values will on a regualr basis

Therefore i may intial thinking was that the actuals values would be pulled via import mode with the forecast values being direct query - there would be quite a lot of rows alltogether so wouldnt want all the data pulling back via direct query 

i just wondered if anyone could provide advice on the best way to create the model, is is best to have 2 x fact tables, Actuals in import and forecast in direct query or is there a better way to handle

thanks in advance 

David 

[v-yanjiang-msft]

Hi @davidv85 ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[amitchandak · Accepted solution]

@davidv85 , All common dimensions and actual as import mode. Forecast as direct query

If you are a  premium customer check the hybrid table

https://towardsdatascience.com/hybrid-tables-in-power-bi-the-ultimate-guide-bfe07d480275

https://www.youtube.com/watch?v=HckuKYlx8kk