PBI doesn't load the right date from Power Query

Hi all,

In my Power Query I have a project showing the Date as 01/08/2020 after all modifications (first parsing date (because somehow it avoided some date errors with other datetime columns) and later transformed it to Date). That date is fine. But If I go to the Table view, the same project shows as 31/07/2020. The data base is up to date.

The original date is 2020-08-01T00:00:00+01:00, then I have two steps resulting in 01/08/2020, but in desktop the result is 31/07/2020. Why? Here the two steps in PQuery.

1) = Table.TransformColumns(#"Expanded PreawardLiaison1",{{"FunderDeadline", each Date.From(DateTimeZone.From(_)), type date}, {"BidSubmittedDate", each Date.From(DateTimeZone.From(_)), type date}, {"BidAwardedDate", each Date.From(DateTimeZone.From(_)), type date}}). Gives as result 01/08/2020.

2) = Table.TransformColumnTypes(#"Renamed Columns",{{"ProjectID", Int64.Type}, {"ProjectTitle", type text}, {"Status", type text}, {"ProjectType", type text}, {"Funder", type text}, {"HESAFunderCategory", type text}, {"NameofCall", type text}, {"FunderDeadline", type date}, {"BidSubmittedDate", type date}, {"BidAwardedDate", type date}, {"ProjectLead.Login", type text}, {"ProjectLead.Display", type text}, {"CoInvestigators.Login", type text}, {"CoInvestigators.Display", type text}, {"LeadOrganisation", type text}, {"Collaborators", type text}, {"Subawardees", type text}, {"Partners", type text}, {"OtherOrganisations", type text}, {"LeadOrgUnit", type text}, {"Themes", type text}, {"ResearchCentresGroups", type text}, {"PreAwardLiaison", type text}, {"BusinessLiaison", type text}, {"PricetoFunderexPartnerCosts", type number}, {"LeadSubproject", type text}, {"OrgUnit", type text}, {"PricetoFunder", type number}}). Keeps the result as 01/08/2020.

Thanks.