Forum Discussion
Support for SQL the language...
Hi All,
We are asking for Developers to start working with Power BI Desktop and the question has come up about SQL support.
So they are asking for getting data using SQL 200 language is it supported?
Can you call a stored procedure from Power BI?
Can you do group by's using SQL language?
Seems to me like it might be but I am not sure it is. Sorry for the newbe questions. Developers work at a different level.
-Tony
Hey Anonymous
I'm going to answer your questions in order as best I can:
So they are asking for getting data using SQL 200 language is it supported? - The simple answer is no. Power BI uses Power Query like excel which uses the lanugage M. You can embed SQL language in M, but M is simple enough and similar enough to SQL this is not usually necessary. When you use "Get Data" from SQL you can use an SQL Query.
Can you call a stored procedure from Power BI? - Yes. Check out these links for more information on this:
1. https://intellipaat.com/community/3763/how-to-use-sql-server-stored-procedures-in-microsoft-powerbi
2. https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
Can you do group by's using SQL language? - Check out these links:
1. https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
2. https://community.powerbi.com/t5/Desktop/Group-by-and-Having/td-p/448502
If this helps please kudo.
If this solves your problem please accept it as a solution.
3 Replies
Hey Anonymous
I'm going to answer your questions in order as best I can:
So they are asking for getting data using SQL 200 language is it supported? - The simple answer is no. Power BI uses Power Query like excel which uses the lanugage M. You can embed SQL language in M, but M is simple enough and similar enough to SQL this is not usually necessary. When you use "Get Data" from SQL you can use an SQL Query.
Can you call a stored procedure from Power BI? - Yes. Check out these links for more information on this:
1. https://intellipaat.com/community/3763/how-to-use-sql-server-stored-procedures-in-microsoft-powerbi
2. https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
Can you do group by's using SQL language? - Check out these links:
1. https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
2. https://community.powerbi.com/t5/Desktop/Group-by-and-Having/td-p/448502
If this helps please kudo.
If this solves your problem please accept it as a solution.
Hi Anonymous ,
You could also add SQL queries in the "Get data" option.
It can reduce the amount of data and enables you to run queries in Power BI more efficiently.
