Import Data from SQL Server
Importing data from an on-premises SQL Server database
1.In Power BI Desktop, on the Home tab, select Get Data - SQL Server.
2.In the SQL Server database dialog box, enter the Server and Database (optional) names, make sure the Data Connectivity mode is Import, and then select OK.
3.Verify your credentials, then select Connect.
4.In the Navigator dialog box, select the required tables, then select Load.