Data View and Data Query show different data

Thank you everyone for the response.

So here is what I did. I just looked at the advanced editor and saw all the transformations. I created a sql query out of that and I am getting the results that I want. So my problem is solved for now.

However, I am still strugging to understand this. I can see only limited information on PowerBI edit query tab but everything in data view at report level. For instance, when I see a filter in particular column in edit query tab, I see only two values. However, in dataview tab I see many more.

Please note that this PowerBI file was created by someone else with their credentials to connect to SQL server database via import mode. My understanding is that in import mode, security on views in database does not work. Because data is already imported. So everyone will be able to see the same information that the person whose credentials were used to connect to the database can see. Do you think on edit query tab sql database security is still working?

So many values for project comlumn in dataview.Only two values in Edit Query.