Forum Discussion
Composite Data Model - Advice
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
Anonymous , 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
2 Replies
- amitchandak
Super User
Anonymous , 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
- v-yanjiang-msft
Community Support
Hi Anonymous ,
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