Forum Discussion
Solved
Perfomance Questions
Hello Guys, Im still working on my Project with a large dataset. Since I cant use import mode because of the size restriction I have to use direct Query. My Datasource is a database in postgresql...
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
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