Among them, Dynamic M Query Parameters to support SQL Server has the potential to be particularly useful to Power BI platform users, according to Doug Henschen, an analyst at Constellation Research.

Dynamic M Query Parameters is a data preparation tool that enables Power BI users to specify the parameters of a query without having to write code.

When first released, however, it only enabled connections to M-based data sources, which are data sources provided directly by Microsoft or those that were accessible through DirectQuery, such as Amazon Redshift, Snowflake and Google BigQuery.

Now in preview, Dynamic M Query Parameters is able to access new data sources through DirectQuery, including SQL-based Microsoft data sources such as SQL Server, Azure SQL Database and Azure Synapse Analytics, as well as non-Microsoft data sources such as Oracle, Teradata and the SAP HANA relational database.

Henschen called the extension of Dynamic M Query Parameters to support SQL Server and other data sources that Power BI did not previously support “an update of note.” Read On: