Forum Discussion

RobertXiong's avatar
RobertXiong
Icon for Helper II rankHelper II
5 years ago
Solved

how to SQL Statement to create report in Power BI desktop

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

RobertXiong's avatar
RobertXiong
Icon for Helper II rankHelper II
5 years ago

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.