Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago

Automatic page refresh not working on appended table?

I have 2 sql sources imported with direct query. Needs to be direct query so automatic page refresh works. And on these 2 sources files it works perfect. However I need to append these 2 sources in...
Need Help
TanviC24's avatar
TanviC24
New Member
3 years ago

As I can see, the ID field is integer/numeric and your total also match in the appended table.

Can you check if by any chance your ID field is getting summarized in the appended table. 

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Well did not change anything there so that indeed was automatically set to summarize:

    Think that this would be the problem?
    So need to set all the ID's to not summarize?

     

    • TanviC24's avatar
      TanviC24
      New Member
      3 years ago

      Yes, you need to set all ID's to not summarize. 

      I think & hope this will resolve your issue.

       

      • rpinxt's avatar
        rpinxt
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Nope...unfortunately it did not 😞