Group by grayed out

[Simon_F]

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 · Accepted solution]

@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 

[Simon_F]

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