8
In desktop, there's an option to cut-and-paste SQL queries in the SQL Server connector. This then translates the query into M for you. Can you add this so dataflows? I'm aware that you support native sql queries, but your method requires cutting-and-pasting M script from PBI desktop. It would be great to eliminate this step.
STATUS DETAILS
Completed

The ability to write SQL Statements using the SQL Server Database connector exists today within the Advanced Options in the dataflow's Connecting settings configuration.

Comments

A

See 'SQL Native queries' section for example of 'SQL Statement' option. https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/