Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Click Get Data
Click SQL Server
Write Server Name & Datanase
Expand Advanced Options
Under SQL Statement write your query
Click Get Data
Click SQL Server
Write Server Name & Datanase
Expand Advanced Options
Under SQL Statement write your query
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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |