Forum Discussion
the data in the Table view is not sync in Report view
Hello,
I recently met a issue/bug in power bi desktop.
So I updated the sql code of the data source of this power bi model:
Old result: customer_id = 0022, customer_name = "A"
New result: customer_id = 1122, customer_name = "A"
When I navigate data in the Table view, customer_id = 1122, customer_name = "A", the values are correct, corresponds to the new result;
but when I go to the Report view and drag customer_id and customer_name to a visual, the customer_id is atill 0022 for "A"
I refreshed several times and it doesn't work at all.
Did anybody face the same issue/bug?
Hi yinyinlin
If you're seeing a value in the visual that does not appear in the Table view, the most likely explanation is that the visual is pulling data from a different table or through a relationship that introduces older or unrelated data.
If there were an issue with the connection to the data source or the refresh process, it would also affect the Table view — but since the Table view shows the updated value (customer_id = 1122), that indicates the data source was refreshed correctly.
I recommend reviewing your entire model to check:
-
Which table the visual is pulling from
-
Whether there are inactive relationships or duplicated tables
-
Any DAX logic or filters applied in the visual that might be referencing older data
To help further, it would be great if you could share a simplified version of your PBIX file using a public cloud service like OneDrive, Google Drive, or WeTransfer, and post the link here.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
1. Try clearing the cache which you can find under Settings->Global-> Data Load, then refresh your model and check.
2. if it doesn't help try duplicating the table inside the power query, load the cloned table and check.
6 Replies
- Ritaf1983
Super User
Hi yinyinlin
If you're seeing a value in the visual that does not appear in the Table view, the most likely explanation is that the visual is pulling data from a different table or through a relationship that introduces older or unrelated data.
If there were an issue with the connection to the data source or the refresh process, it would also affect the Table view — but since the Table view shows the updated value (customer_id = 1122), that indicates the data source was refreshed correctly.
I recommend reviewing your entire model to check:
-
Which table the visual is pulling from
-
Whether there are inactive relationships or duplicated tables
-
Any DAX logic or filters applied in the visual that might be referencing older data
To help further, it would be great if you could share a simplified version of your PBIX file using a public cloud service like OneDrive, Google Drive, or WeTransfer, and post the link here.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
- Jai-Rathinavel
1. Try clearing the cache which you can find under Settings->Global-> Data Load, then refresh your model and check.
2. if it doesn't help try duplicating the table inside the power query, load the cloned table and check.
Hi yinyinlin,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are facing issues with data source and descrepancy in data loading. As Jai-Rathinavel and Ritaf1983 both responded to your query, please go through their response and check if it solves your issue.
I would also take a moment to thank Jai-Rathinavel and Ritaf1983, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi yinyinlin,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Hi yinyinlin,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
