Query Folding

[Anonymous]

Does the report server support query folding?
I ask why in the server update it does not bring all the data in queries with query folding.

[d_gosbell]

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?

[Anonymous]

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.

[Anonymous]

Good afternoon,

Here is an example of what is happening with the update on the desktop and the report server.

UPDATE REPORT SERVER

[d_gosbell · Accepted solution]

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.

[Anonymous]

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.