Copying SQL query into PowerBI

[mzr]

Beginner to PowerBI.. is it possible to take an existing SQL server query connected to datasource and copy it into PowerBI with the same datasource? 

How do we accomplish this in PowerBI?

[FarhanAhmed1984 · Accepted solution]

Click Get Data

Click SQL Server

Write Server Name & Datanase

Expand Advanced Options

Under SQL Statement write your query

[alice_90]

What If there are multiple joins and within the SQL query and the query itself is around 150 lines of code. ? and in future, what if I need to include additional columns and remove columns in the sql script? should the changes be done in the above dialogue box and reload ? Is that an efficient approach ? Looking for possible suggestions.Thanks in Advance!

[pedro_goncalves]

In that case, you will open the Power BI and go to edit queries. There you select  your data base and click in source, the Power BII will show you the SQL script you`ve created

---

@alice_90 wrote:

What If there are multiple joins and within the SQL query and the query itself is around 150 lines of code. ? and in future, what if I need to include additional columns and remove columns in the sql script? should the changes be done in the above dialogue box and reload ? Is that an efficient approach ? Looking for possible suggestions.Thanks in Advance!

---