No binding to Parameter

[YuLinming2025]

I use SQL to create the data for DataRange table.

select distinct date(time) as date from timetable

I want to bind to a DQ M parameter. But can not show the binding.

[v-prasare]

Hi @YuLinming2025,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[v-prasare]

Hi @YuLinming2025,

We would like to confirm if our community members answer helps resolve your query or if you need further help. your insights are truely valuable to community users,  If you still have any questions or need more support, please feel free to let us know.

@jgeddes & @zenisekd  ,Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[jgeddes · Accepted solution]

You can enable the parameter to load into the model. Is that what you are looking to do? 

(Right click on the parameter and select enable load.)

[zenisekd]

Hi, as far as I know, Power BI desktop wont show in the model view the parameter. You can only see it in the Power Query. 

If you want to see or use parameters in the model, you can:

• Reference them in a query that outputs a table or value.
• Load that query into the model (e.g., a single-cell table with the parameter value).
• Then it will appear in the Model view as a table or column.