Forum Discussion

kapurastki's avatar
kapurastki
Regular Visitor
2 years ago
Solved

Reduce direct query mode loading time

Hi all,   I had created a report with a direct query mode. However, the data size is too large and it needs several minutes to retrieve the data. Is there any solution that I can retrieve part of t...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    kapurastki 

    ways to reduce diretquery loading time : 

    1. Data Source Optimization: Ensure that your data source is optimized for performance. This includes indexing tables, optimizing queries, and minimizing the number of joins and transformations.

    2. Query Folding: Leverage query folding wherever possible. This means pushing data transformation steps back to the data source, allowing Power BI to generate more efficient queries.

    3. Use Parameters: Utilize parameters to filter data at the source whenever possible. This can help reduce the amount of data being fetched from the source.

    4. Aggregation: Consider pre-aggregating data at the source or using aggregations in Power BI to reduce the amount of data that needs to be queried. ( use aggs features in power bi ) 

    5. Indexing: Ensure that your data source tables are properly indexed to improve query performance.

    6. Parallel Queries: If your data source supports it, consider enabling parallel queries to allow Power BI to retrieve data more efficiently.

    7. Data Model Optimization: Optimize your Power BI data model by reducing the number of tables and columns, and removing unnecessary relationships and calculations.

     

    hope this helps /

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏