Forum Discussion
Create Parameter (Lookup) for Server from a Country/Region Parameter
Thanks for the reply, Eason.
Yes, it's probably a cascading parameter that would be needed.
My report needs a specific server name for the transaction data but supporting data is kept in sharepoint tables for which I need a region name to filter the data.
I've managed to get it to work by having a parameter for the region name and a query that reads from a server list, using the region name as a filter. It's a little bit long winded, but it does work.
The trick was getting the query - from the list of servers - to produce a single value.
This step in the server_name query does that:
= FilteredRows{0}[Server]
Then for the transaction query the servername is replaced by #"Server_Name" to pick up the result of the Server_Name query.
Hi， Signore_Ands
If you mean specfifying parameters for the server and database, you can refer to these tutorials.
Making data source parameters easy in Power BI Desktop
Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters
If you are referring to creating cascading parameters, I'm afraid it's currently not supported.
Best Regards,
Community Support Team _ Eason
Thanks for the reply, Eason.
Yes, it's probably a cascading parameter that would be needed.
My report needs a specific server name for the transaction data but supporting data is kept in sharepoint tables for which I need a region name to filter the data.
I've managed to get it to work by having a parameter for the region name and a query that reads from a server list, using the region name as a filter. It's a little bit long winded, but it does work.
The trick was getting the query - from the list of servers - to produce a single value.
This step in the server_name query does that:
= FilteredRows{0}[Server]
Then for the transaction query the servername is replaced by #"Server_Name" to pick up the result of the Server_Name query.