Blank months after scheduled refresh

[Imex197]

Hi folks,

I have a big issue.  Since the May 2021 Version (Server+ Desktop) some of our Sales Reports do not work anymore.

When I´m refreshing those reports in my Desktop version all looks good. They work as well after publishing on the Server. But After a scheduled refresh some visuals do not work anymore. I think it has somthing to do with my Calender and the "createdon" field from my source (Odata MS CRM). 

I simplified the model:

 Leads:

Calender:

Desktop Version:

Report Server after scheduled refresh: --> Blank.

Its very urgent. Thank you in adavance!

Cheers

Imex197

[V-pazhen-msft]

@Imex197 
Check the limitation, see if you can avoid if you match any limitation.
Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Imex197]

Hello @V-pazhen-msft ,

no match. Those connection worked for over 2 years. But since the update it does not work anymore.

[Imex197]

It seems that the server can not transform the "createdon" date. 

For "actualclosedate" my calender table is working fine.

any ideas?