Forum Discussion

sb124p's avatar
sb124p
New Member
5 years ago

Setup ODBC CData Connection in Power BI

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.

Need Help

2 Replies

    • sb124p's avatar
      sb124p
      New Member
      5 years ago

      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"