News

QW_RUN runs a query that has been previously saved and displays the output or passes the query to PROC REPORT. It does not invoke an SQL Query Window session. QW_RUN takes the following arguments: ...
Notice how the original SQL query I used as the source of the table is used as a subquery in this query. This is how Power BI generates its SQL and this is why there are limitations on the SQL you can ...
It also logs got empty sql statement, moving on at debug level, but this is not really what I'd consider "moving on". Steps To Reproduce. In as much detail as possible, please provide steps to ...
Create a blank query in Power Query. Power Query will open the formula bar and name the query Query1, which you can change to Commission Rates. Simply double-click the name and enter the new name ...