Forum Discussion

ozanboy's avatar
ozanboy
Frequent Visitor
7 years ago

Parameter Function ODBC - Navigate between tables

Hi all, In our SQL database every study create another table with different name(ID). With everynew table I have to follow same steps in query editor in order to shape them suitable for my graphs/ch...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

ozanboy you can achieve this by parameter, create new parameter in power query, let's say we call it TableName. 

 

now update your script as below.

 

let
Source = Odbc.DataSource("dsn=XX Database", [HierarchicalNavigation=true]),
Company_Database = Source{[Name="Company",Kind="Database"]}[Data],
#"20190409001_Table" = Company_Database{[Name=TableName,Kind="Table"]}[Data]
in
#"20190409001_Table"