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 Table" is the table where I want incremental refresh on column "Order Date".

=Value.NativeQuery(Fact Table,"select * from Order Date",null,[EnableFolding=true])

But I am facing an error which "Expression.SyntaxError:Token Comma expected" and I am not able to find the problem nor solution for it.

Kindly, guide me if anyone has performed such task.

Need Help
Show and Tell
Tutorial Requests

3 Replies

  • 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"?