How to write query in power BI Desktop?

[rakesh_singh]

Hello,

I am new in powe BI desktop and i want to create a report which would be show data from sql server databas.

I am getting data from SQL database using  below sample Query.

Select * from <TableName> Where <ColName> = <Condition>

So I need to know to how can i write query as above query example in Power BI desktop as MSSQL Server query editor.

Please suggest me by step by step tutorial or link.

Thanks

Rakesh Singh

[GlaiveKiffer]

How am I supposed to write multiple queries?

[v-qiuyu-msft · Accepted solution]

Hi @rakesh_singh,

You can use SQL Server data source in desktop, then write that query.

Best Regards,
Qiuyun Yu