cancel
Showing results for 
Search instead for 
Did you mean: 

Direct Query not Working for Azure Database for PostgreSQL

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. 
Status: New
Comments
v-chuncz-msft
Community Support

@iamhassaan 

 

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