Forum Discussion
Composite Model on Service and Calculate Tables
Composite Model is a fairly complex topic for me, I have some questions that need to be answered.
Let's say I have a composite model built on Direct Query and on an imported Excel file and I want to create some calculated tables inside of it that elaborate data from both cloud storage and the excel file;
- First of all, is this actually possible?
- Can I upload said composite model on PBI Service?
- Regarding those calculated tables, when are they going to update themselves? Would they be updated at all times or would I need to manually update them (besides the excel source part)?
I know these question may sound confusing but I'm confused too.
Any help will be greatly appreciated,
thanks
Hi Anonymous ,
I created some data:
Direct Query:
Import:
You can create a calculation table:
Table = SUMMARIZE('sysdiagrams','sysdiagrams'[name],'sysdiagrams'[diagram_id], "amount",CALCULATE(SUM('Sheet1'[amount]),FILTER(ALL('Sheet1'),'Sheet1'[diagram_id]='sysdiagrams'[diagram_id])))You can publish the calculation table to the power bi service:
The calculation table is equivalent to Import mode. You can configure the gateway, and then you can set the schedule refresh or manually refresh immediately to update the data.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi Anonymous ,
I created some data:
Direct Query:
Import:
You can create a calculation table:
Table = SUMMARIZE('sysdiagrams','sysdiagrams'[name],'sysdiagrams'[diagram_id], "amount",CALCULATE(SUM('Sheet1'[amount]),FILTER(ALL('Sheet1'),'Sheet1'[diagram_id]='sysdiagrams'[diagram_id])))You can publish the calculation table to the power bi service:
The calculation table is equivalent to Import mode. You can configure the gateway, and then you can set the schedule refresh or manually refresh immediately to update the data.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly