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...
I've seen certain operations in Power Query against certain data sources cause problems. You could check the Issues forum and see if it is mentioned and if there is a solution. https://aka.ms/PBI_Comm_Issues
Also, you could use a work-a-round by using DAX SUMMARIZE or SUMMARIZECOLUMNS to create a new table in your data model.