Forum Discussion
Group by on Redshift Data Source Table causes great many active sessions (connection limit exceeded)
Hi, I have a fairly simple report loading 10 tables from a single Redshift Datasource, I never had any troubles so far, until today when I duplicated one of the queries and performed a Group By s...
Hi Anske
If you use direct query, it is unsupported to transform data like "group by".
Also, please check if you use any unsupported data types:
https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html
If error still occurs, please create a support ticket for further analysis.
https://powerbi.microsoft.com/en-us/support/
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
as I remarked in my initial question, I'm NOT using direct query.
Cheers,
Anske.