Store URL in Database Table and use this in SSRS field expression

[BTrees]

Hi All,

In my SSRS report, I am using following code in a field's expression (ACTION>URL)to call another PowerBI report based on the field value

="

https://PBIReportservers.ca/Reports...report?filter=mydatasetinpowerBI/datasetfield

eq " & "'" &Fields!Myfield.Value & "'"

this hard-coded expression is working excellently in many reports. But the requirement is to use predefined values for this expression stored in a database table
I stored some part in database and use as parameter in this expression concatenate with current field value Like
= Parameters!url.Value + Fields!Myfield.Value
OR
Parameters!url.Value & "'" & Fields!Myfield.Value & "'"
and tried many other ways nothing works even though it produces the same results as my hard-coded one when I used a table and displayed both in fields to see the results/(expression with current field value) they return
The Problem:
I am able to open my link in the first part saved in database table but it does not filter the current value of the field as it does when I use hard-coded expression mentioned at the top.
Can any one suggest the appropriate way to do this