Question: how to import data from sql server to power bi?
Answer: In Power BI Desktop, on the Home tab, select Get Data > SQL Server. 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. ...  Verify your credentials, then select Connect.