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.
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 Chen
If 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.