Connection Power bi desktop DB2 Cloud

[Anonymous]

Olá boa tarde

Preciso de uma conexão entre o banco de dados DB2-cloud e o Power Bi Desktop, porém estou recebendo este erro ao fornecer o host e o nome do banco de dados, estou usando as seguintes informações, poderiam me ajudar?

SERVIDOR: xxxxxxxxxxxxxxxxxxxxxxxxxxx.yyyyyyyyyyyyy.apgg.databases.appdomain.cloud:30736

Nome do banco de dados: BLUDB

Não tenho certeza se preciso usar o certificado sslConnection=true e onde usá-lo, também se devo realizar a conexão com jdbc:db2://xxxxxxxxxx

[Anonymous]

Hi @Anonymous ,

To connect to a DB2-cloud database from Power BI Desktop, you need to use the IBM Db2 database connector in Power Query. You can access this connector by selecting Get Data > Database > IBM Db2 database.

In the IBM Db2 database dialog box, you need to specify the server and the database name. The server name should be in the format ServerName:Port, where Port is the port number. The database name should be the same as the one you created in the DB2-cloud service.

Power Query IBM Db2 database connector - Power Query | Microsoft Learn

Microsoft Power BI for real-time reporting of IBM Db2 data: A step-by-step guide

Solved: Power BI connection to IBM DB2 - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.