New data is not loaded after refresh in PowerBI Desktop

[yenteng]

Hi, I have a weird situation here. 

I have 2 PowerBI which is sharing the same source of dataset in which it's the exactly same excel file. After I updated the source data and refreshed both PowerBI in desktop, one is able to load with the new data, but another one did not.

This is strange because by right they are sharing the same source, if one can, why the another cannot?

Need some advice/help here.. Many thanks!

[Idrissshatila]

HEllo @yenteng ,

check the data in power query ( transform data) if it is refreshed there, if yes there would be some filter preventing you of seeing the data.

[yenteng]

Hi @Idrissshatila thanks for the reply, I did checked with the power query, and there is no new data being loaded inside as well. 

And I have also checked all the visual/page filter in the powerbi that not showing the new data, seem like there's no any filter that blocking the new data, as the filter applied in both powerbi are the same.

[Idrissshatila · Accepted solution]

hello @yenteng ,

then you need to check wy it's not loading the new data in power query, did you filter your data in power query  ?

[yenteng]

Thanks so much, just realized there was a filter applied in power query.

[PijushRoy]

Hi @yenteng 

Please right-click on the table and check the Include in Report Refresh option, this should be Turn On to get updated data

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[yenteng]

Hi @PijushRoy thanks so much for the reply as well, the above was enabled. Have found out that it was due to there's a filter applied in my power query.