Forum Discussion

ukaya19079's avatar
ukaya19079
Regular Visitor
3 years ago

Passing Value With Parameters

Hi, 

I have a question. Thank you in advance. 

 

I have 2 datasets. 1st is a reference table, name : Customers and I have CustomerName and Price columns. (this table is not in the model since it is a reference table)

 

2nd table has a stored procedure query, where I have a price parameter. (@price) And there is no connection and no same columns between these 2 datasets.  

 

I am trying to pass the first price to the 2nd price with a parameter, so that when the customer logs into the website with their email, the 1st price pass to the 2nd price. Every customer have different price and when that price passes to the 2nd price, based on the customer,  it will display differently for each customer on the 2nd table.

 

Thank you again if you can please advise. 

1 Reply

  •  

    there is no connection and no same columns between these 2 datasets.  

     

    consider correcting the data models.  Or consider using Power BI Embedded for greater control.