Field Advanced Properties for DirectQuery Parameter Binding Missing

[Powerbreeze]

There seems to be a bug where the Advanced Properties section for binding to a Parameter for DirectQuery randomly disappears.  The report where I have created a bound field no longer shows that section.  Please help.

[v-kkf-msft · Accepted solution]

Hi @Powerbreeze ,

This is a known issue (ICM: 304871615). This will be fixed in the June release of Power BI Desktop, please be patient.

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ollie_mills]

Hi @v-kkf-msft - I am still experiencing this issue - has it been fixed?

[amitchandak]

@Powerbreeze , this is available only for selective databases and there are few limitations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerat...

[Powerbreeze]

It's a SQL database so does not fall under the limitations and I was able to bind it after multiple times it appeared with no rhyme or reason.  But now the parameters are bound, but the field advanced section has disappeared and I cannot get it back.  If I want to unbind the parameter or bind a different parameter I am unable to.  I think it is a bug.