Forum Discussion

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
3 years ago
Solved

Retrive data from visual object to use as parameters in query

Hi all I've this 2 visual object that list YEAR and MONTH from a [Calendar Table] I need to retrieve these 2 records as parameters and use them to refresh the sql query  Please can som...
Need Help
  • DiePic's avatar
    DiePic
    3 years ago

    If can help

    I find the matter, i lose this step:
    "using DirectQuery mode"
    now it's working.

     

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
3 years ago

Hi lbendlin and thanx for reply,

the article you indicate is perfect for me but there is a step that I cannot view

 

can you help me for this?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

- go to the data model view

- select the table that holds your parameter column

- select the parameter column

 

- under Properties scroll all the way down

- expand the "Advanced"  section

- pick the right parameter in the "Bind to parameter"  dropdown

 

 

  • DiePic's avatar
    DiePic
    Icon for Resolver II rankResolver II
    3 years ago

    Hi lbendlin 

    thanks for your patience, but as showed in pictures, I dont find the field "Bind to parameter" in my data model view when is expanded the "Advanced" section...
    for that reason I think to have made some error inside query

    please can you attach some example?

  • DiePic's avatar
    DiePic
    Icon for Resolver II rankResolver II
    3 years ago

    If can help

    I find the matter, i lose this step:
    "using DirectQuery mode"
    now it's working.