Forum Discussion
Helper VMissing Visuals after Append
I've copied a table and filtered it down to 1 row. Then I appended this row and the original table into a new table. The table view ahows the table with all the data, but the any visualisation doesn't show the data. Any ideas would be appreciated!
Hi Walt1010 ,
We are sorry to hear that you are experiencing this issue with Power BI Desktop. Here are a few steps you can try to resolve this issue:
1. Please try refreshing the data in the new table.
2. Please check if there are any relationships that may affect the visualization. If the new table has incorrect relationship with other tables, it may not be displayed correctly. Also, check if there are any filters applied to the visualization that may exclude the new data.
3. If the visualization uses measure or calculated columns, make sure they reference the new table correctly.If these didn't solve your issue, please share more details about it in a screenshot or a pbix file (with sensitive data removed) so that we can better help you solve the problem.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Walt1010 ,
We are sorry to hear that you are experiencing this issue with Power BI Desktop. Here are a few steps you can try to resolve this issue:
1. Please try refreshing the data in the new table.
2. Please check if there are any relationships that may affect the visualization. If the new table has incorrect relationship with other tables, it may not be displayed correctly. Also, check if there are any filters applied to the visualization that may exclude the new data.
3. If the visualization uses measure or calculated columns, make sure they reference the new table correctly.If these didn't solve your issue, please share more details about it in a screenshot or a pbix file (with sensitive data removed) so that we can better help you solve the problem.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Walt1010 ,
Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Walt1010Thanks for your reply. As soon as I saw it I began methodically working through all the measures that I used in the report, and I soon relaised that I had several that still referenced the "parent" table and not the one that was the result of the append. Once I changed them the visuals worked fine. Thanks again.