Learn how to update SQL Server data

[bitheerani319]

Put Tutorials
In this tutorial, you explore how to refresh a Power BI dataset from a relational database that exists on-premises in your afghanistan mobile database network. Specifically, this tutorial uses an example SQL Server database, which Power BI must access through an on-premises data gateway.

In this tutorial, you complete the following steps:

Create and publish a Power BI Desktop (.pbix) file that imports data from an on-premises SQL Server database.
Configure data source and dataset settings in Power BI for SQL Server connectivity through a data gateway.
Set up a refresh schedule to ensure your Power BI dataset has recent data.
Perform an on-demand refresh of your dataset.
Examine the update history to analyze the results of the last update cycles.
Clean up resources by deleting the artifacts created in this tutorial.
Prerequisites
If you don't have one, sign up for a free Power BI trial before you begin.
Install Power BI Desktop on a local computer.
Install SQL Server on a local computer and restore the sample database from a backup . For more information about AdventureWorks, see Installing and Configuring AdventureWorks .
Install an on-premises data gateway on the same local computer as SQL Server (in production, this would typically be on a different computer).
Observation

If you are not a gateway administrator and do not want to install a gateway yourself, contact a gateway administrator in your organization. They can create the data source definition required to connect your dataset to your SQL Server database. If you plan to use a stored procedure, use the Import Data connectivity mode.

Create and publish a Power BI Desktop file
Use the following procedure to create a basic Power BI report using the AdventureWorksDW database. Publish the report to the Power BI service, so that you get a dataset in Power BI, which you can then configure and refresh in the following steps.