Forum Discussion
Query Folding
It's really hard to tell from just a screenshot, but my guess would be that you have some issue with date parsing. Maybe there is a slight difference in the local setting between your client and server or you have some dates stored as strings that then have to be cast during the join operation.
If your Jan, Feb, Mar dates are stored as "1/1/2020" , "1/2/2020", and "1/3/2020" which would be common for a lot of the world outside the US, if these were interpreted using a US local they would appear to be 1 Jan 2020, 2 Jan 2020 and 3 Jan 2020 which might explain why all your data is appearing in Jan. Issues with regional settings can be notoriously tricky to track down as there could be settings at the server, user profile and application level to consider.
I'd suggest you start by tracing the queries sent to the data source. Then run them outside Power BI and see what the results look like.
It's really hard to tell from just a screenshot, but my guess would be that you have some issue with date parsing. Maybe there is a slight difference in the local setting between your client and server or you have some dates stored as strings that then have to be cast during the join operation.
If your Jan, Feb, Mar dates are stored as "1/1/2020" , "1/2/2020", and "1/3/2020" which would be common for a lot of the world outside the US, if these were interpreted using a US local they would appear to be 1 Jan 2020, 2 Jan 2020 and 3 Jan 2020 which might explain why all your data is appearing in Jan. Issues with regional settings can be notoriously tricky to track down as there could be settings at the server, user profile and application level to consider.
I'd suggest you start by tracing the queries sent to the data source. Then run them outside Power BI and see what the results look like.
Good Morning,
Your observation is correct. I performed the conversion of the column to date in porwerbi instead of the power query, because when converting through the transformation step of the power query, the step breaks the process of query folding from that point on.
This process left the date column in the USA format, instead of the PT-BR format I need.
Do you know how to convert the date column by power query without interrupting the query folding?
Thanks.