Forum Discussion
Anonymous
2 years agoNot applicable
Direct Query performance issue
Hi Everyone, I'm currently utilizing Direct Query Mode in Power BI for our dashboards. However, we're experiencing performance issues with SAP when multiple users are accessing the reports simultane...
suparnababu8
Super User
2 years agoHi,
Pls follow some strategies to help alleviate the load on your database and reduce system consumption:
- Query Reduction: Enable query reduction options in Power BI settings to minimize the number of queries sent to the database
- Avoid Complex Queries: Simplify Power Query transformations to ensure each query maps directly to a single relational database source table or view
- Analyze Performance: Use the Performance Analyzer in Power BI to identify and optimize slow-running queries
Implementing these strategies should help improve the performance of your Power BI reports and reduce the load on your SAP database