cancel
Showing results for 
Search instead for 
Did you mean: 

Report Server does not show data after schedueld Refresh

Since the May 2021 Version (Server+ Desktop) some of our  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 something to do with my Calender and the "createdon" field from my source (Odata MS CRM). Other data fields as "actualclosedate" doesn´t have this issue. 

Imex197_2-1627646696643.png

Imex197_3-1627646719526.png

 

Imex197_4-1627646775599.png

--> I think the server does not follow the aplied steps correctly

Desktop:

Imex197_5-1627646873197.png

Server after refresh:

Imex197_6-1627646896245.png

 

 

Status: New
Comments
Imex197
Helper I

Hello,  I found a similiar issue regarding dataflow. 

Dataflow refresh error Date/Datetime - Microsoft Power BI Community

 

Could someone from Microsoft please respond to me?!

v-chuncz-msft
Community Support

@Imex197 

 

The latest version works fine for me. Try to recreate the report.

Imex197
Helper I

@v-chuncz-msft 

 

We have the latest version installed. Still the problem with Date/Datetime. 

Desktop Version:

Imex197_4-1627903550962.png

Report Server after scheduled refresh:

Imex197_5-1627904391940.png

 

Power Query: Date, Time and Timezone

Imex197_2-1627901361001.png

 

Change to date:

Imex197_3-1627901789370.png

 

I have no idea why this is happening....

 

 

Imex197
Helper I

@v-chuncz-msft 

Export data to csv, I´m receiving different values.

Before refreshing the report on the server:

Imex197_0-1627908440334.png

 

After scheduled refresh:

Imex197_1-1627908485969.png

 

--> Some how the time is changing during the data refresh on the server.