Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Attach Views, doubt

Good.

I have appended 5 views in a single table, after a few days, when I make my measurements, I discover that the new table does not have all the data of one of the views. I've re-created a new view in the same way and now I do see that data.

My doubt is, the new table is updated, every time the views are updated? it is to find a logic to error.

Greetings.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

    Could you please add some more information on how the data is appended and the source of the data in order to find a solution to this. 
    Also, this seems like it might be a Power Query issue and I suggest posting in that forum.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      OK I comment.

      The database is in SQL SERVER on a remote server.

      Connect to the database using the import method.

      Through Power Query, I append the 5 views and I have a single table with all the data.

      IF I filter that 1st table I can't find the data I'm looking for, but I can filter in one of the views if it appears to me.

      Now when I have recreated a 2nd table if it appears to me.

      So my question is if the table is updated when I update everything?

      Greetings.