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,