Forum Discussion
Data has not Populated in Report Server
Hi team,
Give Suggestion for my issue, in report data not being populated after schedule refresh run successfully in power bi service, but while i am download the report, in Power BI desktop the data has been populated for that report. datasource and other configuration are fine. Same I replaced the report from Power BI Desktop to Power BI Service the data has displayed, afterschedule refresh has been run successfully. data not displayed .
Kindly provide the soluti
Hi Anonymous ,
1. 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:
2. 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
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.
4 Replies
arvindsingh802 Give me Suggestion for this solution
- arvindsingh802
Community Champion
Is this report is direct query ?
If receving error message, share that
if possible share screenshot of the page from web
Hi Anonymous ,
1. 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:
2. 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
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.
