How to connect a dataset to a SQL Server database

0 votes
How to connect a dataset to a SQL Server database?pow
Nov 18, 2020 in Power BI by anonymous
• 10,500 points
210 views

1 answer to this question.

0 votes

In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network. Follow these steps to add your on-premises SQL Server database as a data source to a gateway and then connect your dataset to this data source.

  1. Sign in to Power BI. In the upper-right corner, select the settings gear icon and then select Settings.

  2. On the Datasets tab, select the dataset AdventureWorksProducts, so you can connect to your on-premises SQL Server database through a data gateway.

  3. Expand Gateway connection and verify that at least one gateway is listed. If you don't have a gateway, see the Prerequisites section earlier in this tutorial for a link to the product documentation for installing and configuring a gateway.

  4. Under Actions, expand the toggle button to view the data sources and select the Add to gateway link.

  5. On the Gateways management page, on the Data Source Settings tab, enter and verify the following information, and select Add.

  6. On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.

answered Nov 18, 2020 by Gitika
• 65,850 points

Related Questions In Power BI

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
• 33,010 points
638 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,010 points
4,823 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
18,781 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,010 points
8,789 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,010 points
351 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,500 points
45,529 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
13,445 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4, 2020 in Power BI by Roshni
• 10,500 points
223 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,850 points
1,489 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,850 points
3,714 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP