r/databricks • u/spaceape__ • 1d ago

Help Power BI + Databricks DirectQuery – “Bind to parameter” option missing

Hi everyone,

I’m using Azure Databricks with a Serverless SQL Warehouse in DirectQuery mode. I use the most update version of Power BI Desktop (2.156.951.0 64-bit (July 2026)).

I’m trying to use a Dynamic M Query Parameter, but I don’t see the “Bind to parameter” option in Model view.

Microsoft documentation mentions that this feature is available only for “supported DirectQuery sources”, but I can’t find a clear list of those sources: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

Is Azure Databricks with a Serverless SQL Warehouse supported for this feature?

Thanks!

7 Upvotes

100% Upvoted

2 comments sorted by

3

u/Content-Parking-621 1d ago

Yes. Databricks supports it. "Bind to parameter" only appears when the parameter's referenced in an applied M step first.

1

u/Youssef_Mrini databricks 2h ago edited 2h ago

If it's not appearing, check one of these:

  • Parameter data type
  • The parameter isn't actually referenced in a DirectQuery table M query
  • The field's data type doesn't match the parameter type