query

[vinodhkannan]

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?

[Eric_Zhang]

---

@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?

---

@vinodhkannan

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.

[d_brew]

@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?

[vinodhkannan]

@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.