Forum Discussion

Frequent Visitor

1 year ago

Solved

Group by grayed out

Any idea why I can't select Group by? I have tried on different reports, based on different data sources and it is not available in any. Never seen this before. Many thanks.

nandic
1 year ago
Simon_F , do you use Import model or DirectQuery when connecting to database?
If you use DirectQuery when connecting to database, Group by option will be greyed out as it is not supported.
If you use Import mode, it should be available.

Cheers,
Nemanja

Frequent Visitor

1 year ago

Sorry, I just realised that it's under "Transform" tab: