Power BI Dynamic Parameter in Direct Query
In Power BI, you may want to pass the filter value user selected as parameter to your direct query data source to SQL Server. You can achieve this using dynamic M parameter.
Please note, Bind to parameter option will NOT be available in Power BI unless a Direct Query query presence.
In Power Query Editor, create a M parameter using Manage Parameters. The data type for the parameter needs to match with the type of data you try to bind with.
Posted by John Liu Wednesday, August 7, 2024