Power BI with PgBouncer

Hi all,
I am using Power BI desktop and connecting to azure database storage via PgBouncer v1.17 in direct query mode.

1. On using session as pooling mode in PgBouncer, power bi visuals load fine and no failures.
2. On using transaction as pooling mode in PgBouncer, power bi visuals are failing randomly with error Exception while reading from upstream.

I have a report which has 10 visuals on a page.
These are the logs in PgBouncer for the same failures:

2023-07-13 06:21:57.818 UTC [1] DEBUG loopcnt full
2023-07-13 06:21:57.820 UTC [1] DEBUG S-0x7fd11349c470: foo/[email protected]:5432 S: param: is_superuser = off
2023-07-13 06:21:57.820 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 setting client var: is_superuser='off'
2023-07-13 06:21:57.820 UTC [1] DEBUG S-0x7fd11349c470: foo/[email protected]:5432 S: param: session_authorization = bar
2023-07-13 06:21:57.820 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 setting client var: session_authorization='bar'
2023-07-13 06:21:57.820 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 query time: 1752 us
2023-07-13 06:21:57.820 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 transaction time: 1752 us
2023-07-13 06:21:58.191 UTC [1] DEBUG S-0x7fd11349c240: foo/[email protected]:5432 S: param: is_superuser = off
2023-07-13 06:21:58.191 UTC [1] DEBUG C-0x7fd1134a3680: foo/[email protected]:60528 setting client var: is_superuser='off'
2023-07-13 06:21:58.191 UTC [1] DEBUG S-0x7fd11349c240: foo/[email protected]:5432 S: param: session_authorization = bar
2023-07-13 06:21:58.191 UTC [1] DEBUG C-0x7fd1134a3680: foo/[email protected]:60528 setting client var: session_authorization='bar'
2023-07-13 06:21:58.191 UTC [1] DEBUG C-0x7fd1134a3680: foo/[email protected]:60528 query time: 1905 us
2023-07-13 06:21:58.191 UTC [1] DEBUG C-0x7fd1134a3680: foo/[email protected]:60528 transaction time: 1905 us
2023-07-13 06:21:58.357 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 query time: 297257 us
2023-07-13 06:21:58.357 UTC [1] DEBUG C-0x7fd1134a3220: foo/[email protected]:60526 transaction time: 297257 us
2023-07-13 06:21:58.914 UTC [1] LOG S-0x7fd11349c470: foo/[email protected]:5432 closing because: server conn crashed? (age=2s)
2023-07-13 06:21:58.914 UTC [1] LOG C-0x7fd1134a3680: foo/[email protected]:60528 closing because: server conn crashed? (age=3s)
2023-07-13 06:21:58.914 UTC [1] WARNING C-0x7fd1134a3680: foo/[email protected]:60528 pooler error: server conn crashed?
2023-07-13 06:21:58.916 UTC [1] LOG S-0x7fd11349c240: foo/[email protected]:5432 closing because: server conn crashed? (age=2s)
2023-07-13 06:21:58.916 UTC [1] LOG C-0x7fd1134a3450: foo/[email protected]:60552 closing because: server conn crashed? (age=3s)
2023-07-13 06:21:58.916 UTC [1] WARNING C-0x7fd1134a3450: foo/[email protected]:60552 pooler error: server conn crashed?
2023-07-13 06:21:58.918 UTC [1] ERROR sbuf_send_pending: no dst sock?
2023-07-13 06:21:58.918 UTC [1] ERROR sbuf_send_pending: no dst sock?
2023-07-13 06:21:58.919 UTC [1] ERROR sbuf_send_pending: no dst sock?
2023-07-13 06:21:58.920 UTC [1] ERROR sbuf_send_pending: no dst sock?
2023-07-13 06:21:58.922 UTC [1] ERROR sbuf_send_pending: no dst sock?
2023-07-13 06:21:58.923 UTC [1] ERROR sbuf_send_pending: no dst sock?

I wanted to know two things

1. What is recommended polling mode in PgBouncer for Power BI?

2. Why does Power BI visuals fail randomly with transaction pooling mode? What is the root cause and fix?

Thanks