Support for SQL the language...

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

3. https://stackoverflow.com/questions/37589448/how-to-use-sql-server-stored-procedures-in-microsoft-powerbi

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.