Create a graph using a SQL

[Anonymous]

Hi there all: 

I'm a newbie in Power Bi and I was given the responsability of creating a report with PowerBi Desktop.

My question is realted about how to creating Charts. 

My equipment is the following:

I got a MySQL database on-premise. I used "Import" mode to create my report.

My question is the following:

It's is possible to create a Graph/Plot/Chart with a SQL Query? 

For example:

Use the query: SELECT prices, dates FROM example_table

Which gives the result of a Bar char:

[amitchandak · Accepted solution]

@Anonymous , No, You have to bring in Data using import mode or direct query mode (You can use SQL while bringing in data) .

And using the table in power bi , you need to create visual

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery