Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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.
Solved! Go to Solution.
Hi, @Syndicate_Admin
The table will be updated if you don't disable the option 'include in report refresh'.
Best Regards,
Community Support Team _ Eason
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.
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.
Hi, @Syndicate_Admin
The table will be updated if you don't disable the option 'include in report refresh'.
Best Regards,
Community Support Team _ Eason
Hello and thanks for the answer, it was what I needed to confirm.
Greetings.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 22 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 67 | |
| 56 | |
| 45 | |
| 42 | |
| 30 |