connect PostgreSQL, hyperscaler DB in power BI desktop

[amit_pl]

Hi,

We have one PostgreSQL, Hyperscaler Option service instance created on our BTP Subaccount.
I want to establish connection between power BI desktop and Database created on PostgreSQL service instance.

Can some please explain how we can achieve that.

[manoj467]

I am also looking solution for the same issue. If you are able to achieve it, can you please let me know how you did it. Thanks.

[amit_pl]

Not able to connect DB instance directly so written one secured API using that retrieving data.
For dynamic token generation refer: 
https://advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/