Forum Discussion

Ivy_16's avatar
Ivy_16
Frequent Visitor
4 years ago

Convert data in to native query for incremental refresh

Hi Everyone, I hope that you are all Ok. I am working on incremental refresh and using a dummy data in excel for performing a test on incremental refresh.The following M code is used, i-e "Fact Tab...
Need Help
Show and Tell
Tutorial Requests
BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Ivy_16 ,

 

I'm not an expert in this function myself but, assuming that you have copied out the code exactly as it appears in the formula bar, my first guess would be that Fact Table needs to either be "Fact Table" or #"Fact Table".

 

Pete

  • Ivy_16's avatar
    Ivy_16
    Frequent Visitor
    4 years ago

    I tried that as well and it doesn't work either.

     

    Expression.SyntaxError: Token Literal expected.

    • AlexisOlson's avatar
      AlexisOlson
      Super User
      4 years ago

      It's expecting a table reference in the first argument. Is your fact table query named exactly "Fact Table"?