Data refreshes in Power Query of Power BI Desktop but not showing in visuals

[MeghaDas]

Hi everyone,

I'm facing an issue where my data refreshes successfully in Power Query, but the changes are not reflected in the report visuals on the front end.

Here’s what I’ve done:

• I refreshed the data inside Power Query, and the preview shows updated data.

• But after closing Power Query, the visuals still show the old data.

Could someone help me understand what might be causing this?

Am I missing a step after refreshing in Power Query?

Thanks in advance!

[MasonMA]

@MeghaDas 

Hi, once done in Power Query did you click 'Close & Apply' or 'Apply' (changes are loaded into the report model if you click these two), or did you just click 'Close'?

Hope this helps:)

[MeghaDas]

Thanks for the response.

Yes, I did click ‘Close & Apply’ after refreshing in Power Query, so the changes were applied to the model. But still, the updated data is not showing in the visuals.

Any idea what else could be causing this?

[MasonMA]

Hi, there may have many possibilities that your changes are not reflected in the visuals.

You may need to check if there are visual-level filters applied that filter the new data out. or relationships are broken or missing. 

Or, if the new data doesn't recalculate properly due to logic in DAX measures or calculated columns, visuals may show stale or partial data...

[MeghaDas]

I found the issue — the data in the data model hadn’t been refreshed. After refreshing the data model properly, everything worked as expected and the visuals updated.
Thank you!!

[MasonMA]

I thought you mentioned you had already forced refresh in Power Bi after @jgeddes advised you this. Then you should give kudos to @jgeddes 🙂

[jgeddes · Accepted solution]

The first troubleshooting step would be to refresh the data from main editor. That should force a refresh of your complete model.

[MeghaDas]

First of all, thank you so much for taking the time to respond.
I just wanted to mention that I did try refreshing in the main Power BI editor as well (not just in Power Query), but unfortunately the data still isn't updating in the report visuals.

Do you have any other suggestions I could try?

[jgeddes]

The next thing I would be looking for are any filters or slicers that are active. Including filters on the filter pane. 

[MeghaDas]

Actually my data had not been refreshed in data model. So i did It. Now its working
Thank you!!