Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.