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.
Macwin，
"are there more options to improve the perfomance or am I something missing ?"
I didn't find more options to improve the performance. In Fact, this official document is quite comprehensive.
Power BI performance best practices
"Should I switch to an other sql server model ? like mssql or azure sql for better synergy ? "
I don't think it's necessary. All DirectQuery requests are sent to the source database, so the required visual refresh time depends on how long that back-end source takes to respond with the results from the query (or queries).
"Does it take that long because Im using everything on a local computer (psql server, bi desktop) ? "
This is a factor. You can refer to the official document :
Use DirectQuery in Power BI Desktop
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.