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 - So I have developed power BI File connecting to MSSQL Database, amd I am using around 8 tables. The report is as expected. Is it possible for me to convert this to a SQL query?
@vinodhkannan wrote:
Hi - So I have developed power BI File connecting to MSSQL Database, amd I am using around 8 tables. The report is as expected. Is it possible for me to convert this to a SQL query?
What do you mean "convert to a SQL query"? As you use 8 tables, so you may have to create 8 individual queries to get data. Alternatively your can get data by SQL with Tables JOIN statement accordingly if you don't think all individual tables are necessary.
@Eric_Zhang I think what @vinodhkannan was trying to do is convert the M query to SQL. Even if he has 8 tables as the result of 8 separate queries, could those 8 queries be turned into SQL?
As in my case, I'm using T-SQL to query SQL Server 2012 DB using the native sql query functionality in PowerBI. However, if I build a query using M within PowerBI, I couldn't then use that code to query the database directly in SSMS or use that code to use in a stored proc, or build a view, etc.
I am looking for a compiler that would take the M code and produce valid SQL, but I'm not sure if that currently exists?
@d_brew I did a little bit of research on this, as far as I had seen that kind of conversion (M query to SQL) was not possible.
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 |
---|---|
15 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |