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.
Yes it does. The server is running the same version of the Power Query engine that you see in the Power BI Desktop version that matches the server release. So if you see that query folding is happening when you refresh from Desktop you should see the same folding happening when refreshing on the server. Are you saying you are seeing differences?
Good Morning,
I have the same version of the desktop and server. Exactly, I update on the desktop, but the server does not see the same information. I don't understand why this behavior. I repeated the update several times and ended up returning the previous query, without query folding.
If you need more information, I am available.
Thanks.Good afternoon,
Here is an example of what is happening with the update on the desktop and the report server.
UPDATE REPORT SERVER
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.