Forum Discussion

ollie_mills's avatar
ollie_mills
Icon for Helper I rankHelper I
4 years ago
Solved

Bind to parameter bug (ICM: 304871615)

I am experiencing the same bug as per this community post: https://community.powerbi.com/t5/Desktop/Field-Advanced-Properties-for-DirectQuery-Parameter-Binding/m-p/2553847

 

It is apparently a known issue and was due to be fixed in the June release of Power BI desktop (ICM: 304871615). Has this been fixed?

 

I am using a directquery connection to MS-SQL, sometimes I am able to bind my parameters, but if I open the file the next day - or if i'm working on the file for a long time, the bind to parameter option is no longer available and my slicers don't work.

Need Help
  • ollie_mills's avatar
    ollie_mills
    4 years ago

    To anyone stumbling on this post - I got in touch with microsoft and the bug wasn't fixed in June, but should be working as of the August desktop update

7 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi ollie_mills 

    Thanks for reaching out to us.

    >>For ICM: 304871615, the model is mixed: DQ+import, when you setup the "Bind to Parameter" option and then close the file and open it again, the option "Bind to Parameter" would be missing.

    This has been fixed in the June release.
    Is your situation consistent with this? Could you please provide some screenshots of it? Thanks.

     

     

    Best Regards,

    Community Support Team _Tang

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

    • ollie_mills's avatar
      ollie_mills
      Icon for Helper I rankHelper I
      4 years ago

      Yes I am still getting these errors. Here's a snip of the power bi desktop version I am using:

      And here's a snip showing that my main query is on direct query:

       

       

      Then I have some parameters in Power Query 

      And these params are referenced in a raw sql query like so:

      The i have tables with values for users to enter their desired parameter value

      But in the Advanced section there is no option to bind to parameter...Note that a few days ago I COULD bind these tables of values to the parameters. I would get about halfway through the binding then the option would just dissapear. Very strange

       

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        I wouldn't be surprised if you see that because you ran into some undeclared limit of the number of parameters you can have etc.

      • ollie_mills's avatar
        ollie_mills
        Icon for Helper I rankHelper I
        4 years ago

        To anyone stumbling on this post - I got in touch with microsoft and the bug wasn't fixed in June, but should be working as of the August desktop update