Strange behavior in PBI Desktop

Hello, Power BI experts!

I have been facing this issue several times and don't know what's going on. If someone knows it, this would be great and I appreciate any help.

So my original report is in Import Mode and as a source I use Azure SQL DB. In Query Editor in one of my tables I have these values for each User ID : 

If I close Query Editor and go to Data view and check the same table I can see the following:

So this value is not transeffered to my model and as a result I couldn't create correct reports and dashboards. But I could clearly see this value in DB itself and the backend part in Power BI Desktop.

I found the way to bring back this value into the report by filtering down to this value in Query Editor, then Saving  the results. After this I could see this value, then once again I go to the Query Editor, skip this filter and "magic" - everything is fine. But only for now. And when customer adds a new value or updates something I couldn't refrect the same changes in the report due to the same issue. And it only happens with one table. I use a query to populate this table:

I suspect that I need to delete this table and recreate from the beginning and that might help but I want to know maybe there is logic here and I have done something wrong during the report building.

Thank you in advance!