topic Re: Blank months after scheduled refresh in Report Server

Blank months after scheduled refresh

Imex197 — Mon, 26 Jul 2021 07:49:07 GMT

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

Re: Blank months after scheduled refresh

Imex197 — Mon, 26 Jul 2021 12:57:50 GMT

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

For "actualclosedate" my calender table is working fine.

any ideas?

Re: Blank months after scheduled refresh

Anonymous — Wed, 28 Jul 2021 07:13:07 GMT

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.

Re: Blank months after scheduled refresh

Imex197 — Fri, 30 Jul 2021 05:17:57 GMT

Hello Anonymous ,

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