Juan Tarquino on 25 Jul 2015 20:18:58
SQL query builder (like the old MS Query) inside Power BI that business users that do not know SQL can use when pulling data from SQL Databases.
- Comments (2)
RE: SQL query builder for Non-SQL Users
Miguel, The feature that you speak of is not sufficient. I've been working on a query that works this way. Using the Power BI editor, the SQL service returns nearly 6 million records to the Power BI desktop and then processes the group by and other parts of the query. If I run this SQL only about 4K records result. Needs some ability to do both here
RE: SQL query builder for Non-SQL Users
Are the Joins and filters defined in the he Query Editor executed at the sql database level? or is all the data from he tables selected pulled and then the join and filters are performed in memory?
My understanding was that everything that the Query Editor does is in memory, so that is why the sql query builder would be much better because it would do the work in the sql server instead.