Visual not showing new data after datasource Combine with new table

[Anonymous]

I have a working visual with table, column chart, area chart, etc. All of them have data source which is one SharePoint list.

As our new system launched, the new data are written to a new SharePoint list.

So I use 

= Table.Combine({Source, #"oldlist", "newlist"})

the new table is named as "CombinedList" to combin both list and applied some steps to make every column looks good.

In Power BI Desktop "Data" view, my data looks good and up-to-date. I can see newlist data.

However, in the visual, I click on every tile and re-add all the fields with 'CombinedList'[fieldnames] 

All the visuals have no error. But all of them are not containing newlist data.

As a test, I create a new table and add the fields of "CombinedList". Everything looks good. I can see data from newlist.

My question is, do I need to delete all visuals and re-create? Or there is some button I need to click? I have already tried the "Refresh" button at the top ribbon home tab.

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Is there an example file or screenshot that shows your problem more visually?

You can refer to the following link to combine the data.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data 

https://radacad.com/append-vs-merge-in-power-bi-and-power-query 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.