Forum Discussion
Perfomance Questions
In this video, they talked about having an aggregated table on the live connection. Check if this can help
Hi Macwin ,
“Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.”
It's better to create the hidden aggregated table in Edit Queries.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In this video, they talked about having an aggregated table on the live connection. Check if this can help
I think this composite feature is perfect for my use case. But im not sure how to correctly setup this up on my project.
This is how I tried to setup up the compositie model.
"AGG Table" and "Hourly updated Tablet" are connected through the time/date column.
Masterdata contains static infos about the gathered items in the direct query table.
Hi Macwin ,
First, take "Direct Query" connection model to get data.
Second, modify the "Storage mode".Manage storage mode in Power BI Desktop
Third, Create relationship between tables.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I already set it up but I don´t know if I set it up correctly
Blue = Import | Red = Dual | Yellow = Direct Query
The masterdata tables are actually only for static infos, like name,etc.
I dont need them for measures.
if this setup is correct, my aggreated table (its a view with group by time) is the problem I think.
Thank you guys composite model works like a charm. Now I only need to setup good aggregated table layers.
Otherwise my .pbix file is gettting over 1 Gig
