Forum Discussion
Connection Power bi desktop DB2 Cloud
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
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.