Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Many thanks!! I will try these suggestions today and forward to some others internally.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |