Forum Discussion

DrPhillip's avatar
DrPhillip
Regular Visitor
5 years ago

Dynamic Database selection from Dashboard/Report

Hi All,   I am very new to Power BI and trying to find out if meet our needs.  We currently have an on Prenmise SQL Server and have an extensive set of paginated reports built for our analysis.  We...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi.

 

We want to do exacly what you did. We want to select the correct (1) Database and (2) Company (in paginated reports) based on User Login ID

We have a mining ERP. Each client has a different database (i.e. not one cloud database where you just have to select the company).  We want to embed Paginated Reports but it does not allow parameters for the Server Name and Database Name like Power BI.  We can use URL parameters to set other parameters but it is not available for the Server and Database parameter settings. 

We want to use the same workspace and/or Apps for all the clients (i.e. not duplicate everything for each company).

Can you please explain where the parameter was passed? Is it in the connection string for Server and Database or is it a parameter that you passed in the stored procedure?

Not sure if we are allowed to communicate directly but my e-mail is [email protected]