parameter passing from URL Servernane and dbname from power bi after publish to URL

[rajecpl]

Hi 

Re: parameter passing from URL Servernane and dbname from power bi after publish to URL (fro changing the dataset)

i have created parameter with servername and dbname now i have published now as servname and dbname should be passed to URL can anybody help me out on this. 

[rajecpl]

Thanks for Reply Filter are for Tables column name and data to filter 

But my requiement is to pass [SQL Servername] & [DBName] and from [SQL Servername] & [DBName] the data to be feteched and show on BI Report.

thte Reason is i have Differnt DB for Every Tenanat(SQL DB)  but the Schema will be same for All Tenants the only Diff is the Data in the Database, so i want to  Pass [SQL Servername] & [DBName].

what is the way out for me on this ,this i been trying for last 3 weeks but could not find any solution even a workaround for this will be help full.

[ibarrau · Accepted solution]

Hi. You can't do it by URL. If you have to change server name and dbname by parameters, you should use this one: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

Like I have said before, those paramters will let you.

I hope that make sense.

[ibarrau]

Hi. That's not possible. The parameters created at PowerBi Desktop are parameters that can be completed at Power Bi Service as a configuration of the refresh. That way you can change it for a refresh:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

The URL parameters for PowerBi can only interact with tables and columns of the model in order to filter the semantic model you are viewing at the opened report: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

I hope that helps,

[rajecpl]

The solution paramter Refeesh Soution i found workaround : 

i used Driect Query : 

from browser user will runt he bleow with requied vlaues.

https://app.powerbi.com/groups/GroupID/reports/ReportID/ReportSection?experience=power-bi&filter=Tab...
eq 'Value'

For above example : TableName/ColumnName : Value

Steps 1 : [From Transorm Data: Select Table and Select Column right click on ColumnName and look for add as new query.
Step 2: Create a paramter , and from Suggested Values Select Query. 
Step 3: go (Model View) SElect the Table and Column , Click on Column , in properties option got to [Advance] [Bind to parameter] SElect the Step 2 paramter.

Now what ever is passed form browser everythig get filtered.