While using direct query mode the maximum groups is ten

[Safety_J]

When using a table that is connected via Direct Query, we are limited to ten (10) groups when using the "Create New Group" function. This is very limiting when you do not own the data source. Is there a fix for this?

[Anonymous · Accepted solution]

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:

1. Group Consolidation: Review your existing groups and consolidate them where possible. Combine similar groups or eliminate unnecessary ones to stay within the limit.

2. 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.

3. 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.

[az38]

Hi @Safety_J 

AS far as I know there is no workaround, but the topic itself is very interesting for investigation.

You can create an idea here https://aka.ms/PBI_Comm_Ideas