Direct Query not Working for Azure Database for PostgreSQL

[iamhassaan]

Our organization have some reports that use Azure Database for PostgreSQL in direct query. Since Afternoon we started receiving errors in all visuals, that use Azure Database for PostgreSQL as the backend using Direct Query.

• Activity IDe603f100-3fbf-468f-bb7b-fbfc6b0ad2e1
• Request ID81939fca-d5f0-2e2e-3df1-12d20b219d80
• Correlation ID4a92ee13-f0dd-8b77-7822-b599a1044676
• TimeMon Sep 06 2021 14:49:34 GMT+0100 (British Summer Time)
• Service version13.0.16691.56
• Client version2108.4.07469-train
• Cluster URIhttps://wabi-uk-south-b-primary-redirect.analysis.windows.net/
  
  Reports that are made using import method, appear to work fine. 

[v-chuncz-msft]

@iamhassaan 

You may try to reduce Max Intermediate Row Set Count to a smaller value.