Forum Discussion
Bind to parameter is missing in modelling advanced properties for parameter
- 4 years ago
Anonymous , are you using a direct query? I think this option is for direct query
refer
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
I had the same issue.
My requirement was to provide a list to the user where he selects a value which is the parameter to load a certain file depending on the filename.
I had only import queries. So in data modelling the bind parameter wasnt showing.
I just added one completely useless DQ query. The "bind parameter" showed up. I could take my parameter from the drop down. But it didnt worked. I went back to the data modelling and even though my table has a parametrized icon the parameter wasnt any longer in the drop down.
I went back to power query editor and changed the name of the parameter. Then it showed up again but still no functionaltiy.
I started a completely new report with the same logic but with DQ to a SQL Server and added the Parameter in the where clause. Everything works as expected. I can choose the value from a list which has the parameter binded and the report updates filtered by this selection.
So obviously there are data connection / data source restrictions but in my first scenario this "bind paramter" showup was very strange and somehow buggy.