New to BI. Writing SQL queries to parse data. I am obviously missing something.

[aspardo]

Started using Power BI on the recommendation of a friend. It looks well made and powerful, so I hope to stick with it.

I am pretty decent with SQL and can write some lengthy queries. My goal is the following:

1) Pull data from out databse

2) Write queries in power BI

3) Publish dashboards / reports based on those queries

I have connected to our database, so step 1 is done.

What I am stuck on is where / how to write actual SQL queries. I want to be able to write a query such as SELECT * FROM shop WHERE X LIMIT 100 and just have it spit out the data, so I can manipulate it, put it into dashboards, and create charts, so later on I can push it to the cloud.