Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

0

Cannot see column property options (need to see Parameter Binding) in the Model View

Hi Power BI community,

 

I am trying to implement parameter binding via a slicer selection / URL query parameter filtering to filter what is returned from SQL. https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 

I have the following question, on a new Power BI report, I can see the following option to bind parameter:

rico_0-1658445781080.png

 

But on my existing report, I couldn't see the option, everytime I select a column it just shows me something like this, as if the column is not detected:

rico_2-1658445855878.png

 

I have checked the settings, and they look identical. Furthermore, the Scenario base table is DirectQuery.

Might anyone have any idea what is happening here? Thank you!

 
Status: Delivered

Hi @Anonymous ,

 

May I know whether you edit the M query in your existing report to make it reference the parameter you created?  As a prerequisite for this feature, you must have a valid M Query Parameter created and referred in one or more Direct Query tables.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

 

And you need to click on specific fields to see its properties that contains Bind to parameter but not the following screenshot which the Properties pane when no tables or fields are selected. If you see it when you click on specific table or field, please make it proper by switching between fields or reopen your report later.

vcazhengmsft_0-1658739147787.png

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @Anonymous ,

 

May I know whether you edit the M query in your existing report to make it reference the parameter you created?  As a prerequisite for this feature, you must have a valid M Query Parameter created and referred in one or more Direct Query tables.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

 

And you need to click on specific fields to see its properties that contains Bind to parameter but not the following screenshot which the Properties pane when no tables or fields are selected. If you see it when you click on specific table or field, please make it proper by switching between fields or reopen your report later.

vcazhengmsft_0-1658739147787.png

 

Best Regards,

Community Support Team _ Caiyun