Power BI Parameterization to Snowflake Data Source

[SruthiK]

Hello, I am trying to set parameterized data source for snowflake in power bi. I am able to parameterize for single database connection it's working and now trying to do for multiple databases. I am using the following query but it's not helping. Please suggest .    let
Source = Snowflake.Databases(Snowflake,DW),
DB_Database = Source{[Name=SnowflakeDB,Kind="Database"]}[Data],
MO_DB =
if DB_Database = "DB1"
then DB_Database = Source{[Name=SnowflakeDB,Kind="Database"]}[Data]
else
DB_Database = Source{[Name="DB2",Kind="Database"]}[Data],
DATAMART_Schema = MO_DB{[Name=SnowflakeSchema,Kind="Schema"]}[Data],
MO_View = DATAMART_Schema{[Name="View_MO",Kind="View"]}[Data],
#"Filtered Rows" = Table.SelectRows(MO_View, each [MONTHINFO] >= #date(2021, 1, 1))
in
#"Filtered Rows"

[v-xiaotang]

Hi @SruthiK 

Thanks for reaching out to us.

Is there any error message when you try to parameterize for multiple databases?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[SruthiK]

Hi, we are not getting any error message and we are not able to get the expected result also we are unable to choose parameters while getting data source.