how to SQL Statement to create report in Power BI desktop

[RobertXiong]

Hi 

I installed Power BI Desktop on my computer, created data connection to database, got dataset in Power BI Desktop. right now I am going to create report base on those tables in the dataset. I already had exist SQL Statement for the report. how can I use the exist SQL Statement to build report ? instead of selecting columns from tables, and building filters etc.

Thanks advanced

Robert

[amitchandak · Accepted solution]

@RobertXiong , You have to create a connection and in advance option, you can give SQL

[Anonymous · Accepted solution]

@RobertXiong 
Unfortunately, Power Bi doesn't support using SQL statement to build report, you can only use it to connect database to Power BI.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[RobertXiong]

Thanks so much, Paul Zheng

[amitchandak · Accepted solution]

@RobertXiong , You have to create a connection and in advance option, you can give SQL

[RobertXiong]

Thanks for your solution. I already created connection to database and already created dataset in Power BI Desktop, it's all ready for building report. I already has SQL Statement like "Select employee_id, employee_name, dept_name, salary from employee, department where .....", actual SQL Statement is much more complicated than this example, that's why I prefer to use this SQL Statement to build report.