Forum Discussion

SruthiK's avatar
SruthiK
New Member
4 years ago
Solved

Parameter Setting for Data Source(Snowflake)

Hi, I added parameter (Snowflake sever instance, data warehouse) and configured in Advanced Editor. When I am trying to add new source i..e, Snowflake in Power BI I am unable to see the option to cho...
Need Help
  • Manendra's avatar
    Manendra
    3 years ago

    SruthiK 

    I follow the below-mentioned method to stitch between different DBs environments i.e. DEV, Test, Prod.

     

    Before creating the report, I import all the tables which are necessary by default approach i.e 

    Get Data > Snowflake > Enter the URL > Warehouse Name.

     

    After importing all necessary tables. I create 3 parameters 

    1. Server Name (ServerName)

    2. Data warehouse (DWH)

    3. Database Name (DB)

     

    Select Advance Editor for any table and replace the code as mentioned below 

     

    Before: 

     

    let
    Source = Snowflake.Databases("XXXXXXXXXXXX.snowflakecomputing.com","extralarge"),
    XX_XX_DEV_Database = Source{[Name="XX_XX_DEV",Kind="Database"]}[Data],
    Your_Schema = NAME_OF_Database{[Name="XX",Kind="Schema"]}[Data],
    TABLE_NAME_YOU_IMPORTED = Your_Schema{[Name="TABLE_NAME_YOU_IMPORTED",Kind="View"]}[Data]
    in
    TABLE_NAME_YOU_IMPORTED

     

    After:

     

    let
    Source = Snowflake.Databases(ServerName, DWH, [CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    Database = Source{[Name=DB,Kind="Database"]}[Data],  // XX_XX_DEV_Database changed to Database, XX_XX_DEV changed to DB 
    Your_Schema = Database{[Name="XX",Kind="Schema"]}[Data],   // Just use the word Database don't change it
    TABLE_NAME_YOU_IMPORTED = Your_Schema{[Name="TABLE_NAME_YOU_IMPORTED",Kind="View"]}[Data]
    in
    TABLE_NAME_YOU_IMPORTED

     

    No need to make any changes in line number 4; I just gave you for reference.

     

    You need to do the above things in each table for the first time only. When ever you want to change the database or server name just go to parameters which you created and switch them.

     

    Let me know if this is helpful. 

     

     

     

Manendra's avatar
Manendra
Advocate I
3 years ago

SruthiK 

I follow the below-mentioned method to stitch between different DBs environments i.e. DEV, Test, Prod.

 

Before creating the report, I import all the tables which are necessary by default approach i.e 

Get Data > Snowflake > Enter the URL > Warehouse Name.

 

After importing all necessary tables. I create 3 parameters 

1. Server Name (ServerName)

2. Data warehouse (DWH)

3. Database Name (DB)

 

Select Advance Editor for any table and replace the code as mentioned below 

 

Before: 

 

let
Source = Snowflake.Databases("XXXXXXXXXXXX.snowflakecomputing.com","extralarge"),
XX_XX_DEV_Database = Source{[Name="XX_XX_DEV",Kind="Database"]}[Data],
Your_Schema = NAME_OF_Database{[Name="XX",Kind="Schema"]}[Data],
TABLE_NAME_YOU_IMPORTED = Your_Schema{[Name="TABLE_NAME_YOU_IMPORTED",Kind="View"]}[Data]
in
TABLE_NAME_YOU_IMPORTED

 

After:

 

let
Source = Snowflake.Databases(ServerName, DWH, [CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
Database = Source{[Name=DB,Kind="Database"]}[Data],  // XX_XX_DEV_Database changed to Database, XX_XX_DEV changed to DB 
Your_Schema = Database{[Name="XX",Kind="Schema"]}[Data],   // Just use the word Database don't change it
TABLE_NAME_YOU_IMPORTED = Your_Schema{[Name="TABLE_NAME_YOU_IMPORTED",Kind="View"]}[Data]
in
TABLE_NAME_YOU_IMPORTED

 

No need to make any changes in line number 4; I just gave you for reference.

 

You need to do the above things in each table for the first time only. When ever you want to change the database or server name just go to parameters which you created and switch them.

 

Let me know if this is helpful. 

 

 

 

Rubanenko's avatar
Rubanenko
Regular Visitor
3 years ago

I have found the following solution to work for me.
First connect to your Snowflake and get the table the shows all the Databases like below

Then Filter your database (This filter will actually will be your parameter later)
Then DELETE all other columns except for 'Data' Column and press the table

Then you will get the Schema table repeat the same steps as above for the schema and table and ensure to delete all fields and keeping only the 'Data' field

Then what is left is to create 3 parameters
Database = DBE
Schema = SCM
Table = TBL

Go to the 'Advance Editor'