Skip to main content
Microsoft Idea

Power BI

Needs Votes

Dynamic M query for T-SQL based data sources.

Vote (30) Share
Y W's profile image

Y W on 03 Dec 2020 04:33:02

Please also support Dynamic M query for T-SQL based data sources.
This is an important feature that can improve performance.

Dynamic M query parameters in Power BI Desktop (preview)
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
------------------
The feature is only supported for M based data sources. The following DirectQuery sources are not supported:
T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (aka Azure SQL Data Warehouse), and Synapse SQL OnDemand pools
------------------