Forum Discussion

Anonymous's avatar
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...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Now what will your query do on Jan 1st 2021? 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Welcome to my first day with Power M. This works:

let
week = Date.WeekOfYear(DateTime.LocalNow()),
strWeek = Number.ToText(week),
Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
#"data-resilient_Table" = gsec_Database{[Name="data-resilient-all-2020"&strWeek,Kind="Table"]}[Data]
in
#"data-resilient_Table"

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Now what will your query do on Jan 1st 2021? 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    crash and burn. I think I can figure out the year. we will see.. I wanted to get this working first to minimize the number of problems I had at one time!!

    Thanks for your help!