Data has not Populated in Report Server

[Udhaya_1993]

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

[v-yangliu-msft · Accepted solution]

Hi  @Udhaya_1993 ,

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:

https://www.c-sharpcorner.com/blogs/reports-doesnt-show-data-in-power-bi-web-service-after-refresh-i...

https://community.powerbi.com/t5/Report-Server/After-a-scheduled-refresh-the-report-has-no-data/td-p...

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.

[Udhaya_1993]

1. We are mapped the stored procedure to the query . the values from stored procedures.

2. No error Messages.

[Udhaya_1993]

@arvindsingh802  Give me Suggestion for this solution

[arvindsingh802]

Is this report is direct query ?
If receving error message, share that
if possible share screenshot of the page from web