Forum Discussion
Improve DirectQuery performance
Hi troc24 - you can create Indexes on the ID columns in both Cosmos DB and Azure SQL. This can significantly speed up join operations and query execution.Optimize the queries in Cosmos DB and Azure SQL to reduce the amount of data being pulled into Power BI and also use filters and aggregations effectively at the source to minimize data transfer.Use the Manage Aggregations feature to map the aggregation table to the detailed table.
Only include necessary columns in your DirectQuery mode. Extra columns increase the amount of data transferred and processed
Reference:Index Creation :
Azure Cosmos DB indexing policies | Microsoft Learn
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn
User-defined aggregations - Power BI | Microsoft Learn
Hope it helps
Super UserHi troc24 - you can create Indexes on the ID columns in both Cosmos DB and Azure SQL. This can significantly speed up join operations and query execution.Optimize the queries in Cosmos DB and Azure SQL to reduce the amount of data being pulled into Power BI and also use filters and aggregations effectively at the source to minimize data transfer.Use the Manage Aggregations feature to map the aggregation table to the detailed table.
Only include necessary columns in your DirectQuery mode. Extra columns increase the amount of data transferred and processed
Reference:Index Creation :
Azure Cosmos DB indexing policies | Microsoft Learn
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn
User-defined aggregations - Power BI | Microsoft Learn
Hope it helps