Setup ODBC CData Connection in Power BI

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"