Forum Discussion

ChainSpart's avatar
ChainSpart
Frequent Visitor
5 years ago
Solved

Parameter Binding - Error (Parameter is not defined in model)

Hello,   I'm working with an SQL database that has a view which needs an input parameter to show values.  This Parameter is related to a table that has a list of names and when we put one of these...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ChainSpart,

    I think you want to use the selected value from the slicer/filter to affect the backend query tables and send them to your database, right?

    If that is the case, you can't achieve this requirement. AFAIK, they are host on different data levels and you can't use child level to affect its parent.

    Notice: the data level of power bi.

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng

ChainSpart's avatar
ChainSpart
Frequent Visitor
5 years ago

Hi,

 

Thanks for your answer. Unfortunately, I already tried that and used this parameter as the Parameter binding. My 1st post wasn't complete it seems.

But when I do use the Parameter binding to this parameter1, it doesn't work, I can't see anything in my table view.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ChainSpart,

I think you want to use the selected value from the slicer/filter to affect the backend query tables and send them to your database, right?

If that is the case, you can't achieve this requirement. AFAIK, they are host on different data levels and you can't use child level to affect its parent.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

  • ChainSpart's avatar
    ChainSpart
    Frequent Visitor
    5 years ago

    Hi @Xiaoxin,

     

    That's exactly what I want/need.

    Thanks for your answer even tho I'm unhappy to read that 😕

    I hope that the "parameter binding" option will allow it in a near future !

     

    Regards