How to connect to sql server from power Bi

0 votes
How to connect to sql server from power Bi?
Mar 22, 2019 in Power BI by Nithin
1,270 views

1 answer to this question.

0 votes

Hi,
Follow these steps to connect to SQL server database:
1. Click on Get Data.
2. Go to Database and select Sql server database.
3. Then Type your server name.
4. Connect data through import(for data+metadata/offline) or direct query(metadata/online) to sql server.
5. Type any Sql statements. (optional)
6. Select mode of authentication (window /database/Microsoft account).
7. Select required tables and fields residing in Sql server database for creating your report and visualization.
8. Click Ok.
9. Now the data is retrieved and is ready to create visualizations.

Hope this helps you.

answered Mar 22, 2019 by Cherukuri
• 33,030 points

Related Questions In Power BI

0 votes
1 answer

How is Power BI Report Server different from SQL Server Reporting Services and the Power BI online service

Power BI report server is deployed on-premises ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,540 points
1,195 views
+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
• 33,030 points
25,656 views
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
• 52,360 points
1,900 views
0 votes
1 answer

Convert an expression from SQL to Power BI

Use the following expression: MyTemperatureTable = FILTER ( Device1234, ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,540 points
605 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,620 points
758 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,620 points
4,372 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

answered Dec 14, 2018 in Power BI by Upasana
• 8,620 points
6,219 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

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

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
11,756 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
• 33,030 points
7,534 views
+1 vote
3 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
30,467 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP