Forum Discussion
While using direct query mode the maximum groups is ten
Hi Safety_J ,
We can't break the limit of ten groups created in direct Query mode, but we can optimize to reduce the number of groups.
Below is some solutions:
-
Group Consolidation: Review your existing groups and consolidate them where possible. Combine similar groups or eliminate unnecessary ones to stay within the limit.
-
Aggregation: Instead of creating separate groups for similar data, consider using aggregation functions within a single group. For example, aggregate sales data by month rather than having ten separate monthly groups.
- Import mode: You can use the import mode instead of the direct Query mode
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
Hi Safety_J ,
We can't break the limit of ten groups created in direct Query mode, but we can optimize to reduce the number of groups.
Below is some solutions:
-
Group Consolidation: Review your existing groups and consolidate them where possible. Combine similar groups or eliminate unnecessary ones to stay within the limit.
-
Aggregation: Instead of creating separate groups for similar data, consider using aggregation functions within a single group. For example, aggregate sales data by month rather than having ten separate monthly groups.
- Import mode: You can use the import mode instead of the direct Query mode
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.