Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |