Forum Discussion

Simon_F's avatar
Simon_F
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.

Need Help
  • nandic's avatar
    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 

2 Replies

  • nandic's avatar
    nandic
    Resident Rockstar
    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 

  • Simon_F's avatar
    Simon_F
    Frequent Visitor
    1 year ago

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