Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need guidance to create a dynamic data source in powerbi

I wanted to create a dynamic datasource with parameter in powerbi

My data is connected from mongodb through odbc connector. And I created my parameter name as "parameter".

Here is what my advance editor looks like

 

 

 

Can anybody give an idea where to place or to replace my parameter name

Wanted to create a dynamic datasource in powerbi with parameter through odbc connector

pls explain

PowerBI PowerQueryFTW powerqueryquest 

 

General Comment
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    3 years ago

    Hello - based on your screenshot you can parameterize the database, table and possibly the DNS.

     

     

      • jennratten's avatar
        jennratten
        Icon for Super User rankSuper User
        3 years ago

        Hello - please try this sample below.  You will need to swap out the highlighted text with the names of your actual parameters.  If your parameter names don't include special characters/spaces then you don't need to add any other characters, otherwise, you will need to wrap your parameter names like this #"param name".  I changed the text before the = sign for the database and table so that they would be applicable in various scenarios.  For example, if your parameter gets values from the food database instead flowers, it would be preferable for the name to not include a reference to flowers.

         

         

         

        let
    Source = Odbc.DataSource("dsn=" & paramDsn, [HierarchicalNavigation=true]),
    database = Source{[Name = paramDb, Kind = "Database"]}[Data],
    data = database{[Name = paramTable, Kind = "Table"]}[Data]
in
    data