Forum Discussion
Data not getting update in the report even schedule refresh successful
Data not getting update in the report even schedule refresh successful and below two check boxs are enable (enabled load, include in report refresh).
Hi LankelaAnilRedd ,
You can try to check the following points:
1. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky
2. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
3. Possibly related to the date:
Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community
4. Is the gateway the latest version, if not, please upgrade to the latest version.
Update an on-premises data gateway | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- GilbertQ
Super User
Hi GilbertQ,
Thanks for the response, yeah i have checked data source and have latest data but data is new data not coming to power bi desktop even after refreshing the data manually but showing all rows loaded like green right mark.
Hi LankelaAnilRedd ,
You can try to check the following points:
1. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky
2. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
3. Possibly related to the date:
Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community
4. Is the gateway the latest version, if not, please upgrade to the latest version.
Update an on-premises data gateway | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
