Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Token EOF Error

I am getting a token eof error on this query and I am not sure why. The week variable prints 26 when I run this with out the database part. let week = Date.WeekOfYear(DateTime.LocalNow()) in w...

lbendlin
6 years ago
Now what will your query do on Jan 1st 2021? 🙂

Anonymous

Not applicable

6 years ago

OK- I need to use the weeknumber in the table name. I knocked it down and now I get this:

DataSource.Error: The table has no visible columns and cannot be queried.
Details:
data-resilient-all-2020week

Super User

6 years ago

Show your new Power Query?

Anonymous
Not applicable
6 years ago
let
week = Date.WeekOfYear(DateTime.LocalNow()),
Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
#"data-resilient-all-2020week_Table" = gsec_Database{[Name="data-resilient-all-2020week",Kind="Table"]}[Data]
in
#"data-resilient-all-2020week_Table"
- lbendlin
  Super User
  6 years ago
  You're still not using the week. Maybe you wanted to do this?
  
  let
  week = Date.WeekOfYear(DateTime.LocalNow()),
  Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
  gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
  #"data-resilient-all-2020week_Table" = gsec_Database{[Name="data-resilient-all-2020" & week,Kind="Table"]}[Data]
  in
  #"data-resilient-all-2020week_Table"
  - Anonymous
    Not applicable
    6 years ago
    warmer, How do I concatentate 2020 and week? It needs to look like data-resilient-all-202026
    Expression.Error: We cannot apply operator & to types Text and Number.
    Details:
    Operator=&
    Left=data-resilient-all-2020
    Right=26