Setup ODBC CData Connection in Power BI

[sb124p]

Hi All,

I am using CData for connecting redis database from power bi. i am able to configure redis connections and access data in power bi. no issue in connection. but what is the problem i am chaleenging is " Want to connect different redis databases (1 to 15) based on user selection in power bi. current i configured logical database as "1" in ODBC data source configuration. but this logical database now has to pass from power bi. it may be any no between 1 and 15. how do I set this in POWER BI.  

Thank You in Advance.

[amitchandak]

@sb124p , not sure this will work for this connector. But check this

https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/

if needed check

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

[sb124p]

Thanks Amitchandak, I am using CData, CData have  different properties.  you shared solution for sql Server.  i am using below query. which properties i can use and where for changing redis logical database no?

let
Source = Odbc.DataSource("dsn=CData", [HierarchicalNavigation=true]),
CData_Database = Source{[Name="CData",Kind="Database"]}[Data],
Redis_Schema = CData_Database{[Name="Redis",Kind="Schema"]}[Data],
Events_Table = Redis_Schema{[Name="Events",Kind="Table"]}[Data],
#"Removed Columns" = Table.RemoveColumns(Events_Table,{"RedisKey"}),
#"Transposed Table" = Table.Transpose(#"Removed Columns"),
#"Parsed JSON" = Table.TransformColumns(#"Transposed Table",{},Json.Document),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Parsed JSON", "Column1", {"Extended", "ExtendedStats", "TypeTeamEvent", "Gender", "EvCode", "Class", "Enable", "EventResultFormat", "Modality", "HasSubunits", "TypeEvent", "Category", "Order", "NSplits", "Records", "Status", "Discipline", "ObjectType", "Key", "ModificationTime"}, {"Extended", "ExtendedStats", "TypeTeamEvent", "Gender", "EvCode", "Class", "Enable", "EventResultFormat", "Modality", "HasSubunits", "TypeEvent", "Category", "Order", "NSplits", "Records", "Status", "Discipline", "ObjectType", "Key", "ModificationTime"}),
#"Removed Columns1" = Table.RemoveColumns(#"Expanded Column1",{"Extended", "ExtendedStats", "TypeTeamEvent"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns1", each ([Enable] = true))
in
#"Filtered Rows"