Question

How to connect to IBM DB2 database from power Bi?

Answer 1

Hi,

Hi,
Follow these steps, to connect to IBM DB2 database.
1. Click on Get Data.
2. Go to Database and select IBM DB2 database.
3. Then Type your server name.
4. Type any Sql statements. (optional)
5. Select mode of authentication (window /database) for first connection to data source.
6. Select required tables and fields residing in IBM DB2 database for creating your report and visualization.
7. Click Ok.
8. Now the data is retrieved and is ready to create visualizations.