topic Re: query in Developer

query

vinodhkannan — Thu, 09 Nov 2017 19:46:23 GMT

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?

Re: query

Eric_Zhang — Fri, 10 Nov 2017 07:07:03 GMT

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

Re: query

d_brew — Mon, 12 Feb 2018 19:30:29 GMT

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

Re: query

vinodhkannan — Mon, 12 Feb 2018 20:26:37 GMT

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