Forum Discussion
Visuals not updating with new data
Hi bobbob123 ,
I’ve experienced a similar issue before, not just in Power BI but also with an Excel Power Pivot linked table, where the refresh wouldn’t work no matter what I tried. In that case, I eventually realized that the connection between the linked table and the data model had been lost, and I had to remove the table and re-add it to the model to restore the link. Given that experience, I suspect something similar might be happening in Power BI.
Since Power Query is loading the data but the visuals aren’t updating, it’s possible that the connection between the table and the report visuals is broken. You could try removing the table from Power Query and re-importing it from Excel, then applying the changes again. If that doesn’t work, duplicating the query with a new name and pointing the visuals to the new table might force Power BI to recognize the updated data. Another workaround is to copy the existing visuals to a new page or create a duplicate of the report page to see if they update there. If a new report works fine but the existing one doesn't, it could indicate an issue with cached metadata in the .pbix file. If all else fails, exporting the data, creating a fresh Power BI file, and re-importing everything might be the best way to resolve it.
Best regards,
Sadly i've tried all that, in the past I've had no issues with updating my simple table. As this is only 1 table with no relationships im just suprised why it just won't update. I don't have any filters on any pages or all pages. I only have visuals on one report that references the same table.
When i create a new report and drag and drop the columns, i see the new data but when I refresh from power query or power bi it just won't update.
Hi bobbob123 ,
I’ve experienced a similar issue before, not just in Power BI but also with an Excel Power Pivot linked table, where the refresh wouldn’t work no matter what I tried. In that case, I eventually realized that the connection between the linked table and the data model had been lost, and I had to remove the table and re-add it to the model to restore the link. Given that experience, I suspect something similar might be happening in Power BI.
Since Power Query is loading the data but the visuals aren’t updating, it’s possible that the connection between the table and the report visuals is broken. You could try removing the table from Power Query and re-importing it from Excel, then applying the changes again. If that doesn’t work, duplicating the query with a new name and pointing the visuals to the new table might force Power BI to recognize the updated data. Another workaround is to copy the existing visuals to a new page or create a duplicate of the report page to see if they update there. If a new report works fine but the existing one doesn't, it could indicate an issue with cached metadata in the .pbix file. If all else fails, exporting the data, creating a fresh Power BI file, and re-importing everything might be the best way to resolve it.
Best regards,
I think this approach seems to work, duplicate the table from power query and then duplicate the report page and then reassign the column for each values seems to update the new data.