How to connect to IBM DB2 database from power Bi?

0 votes
How to connect to IBM DB2 database from power Bi?
Mar 22, 2019 in Power BI by Sindhu
2,054 views

1 answer to this question.

0 votes

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.

answered Mar 22, 2019 by Cherukuri
• 32,440 points

Related Questions In Power BI

0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 51,830 points
479 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 32,440 points
1,021 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

answered Feb 6 in Power BI by Gitika
• 26,310 points
90 views
0 votes
1 answer
0 votes
1 answer
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,440 points
4,528 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,440 points
181 views
0 votes
1 answer

How to connect to IBM DB2 database from Tableau?

Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 32,440 points
188 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,440 points
1,767 views
+1 vote
2 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

answered Dec 20, 2019 in Power BI by Tony
• 160 points
5,618 views