How to refresh Paginated report in both Report Builder & Service.

[prakash11440278]

Hi,

How to refresh Paginated report in both Report Builder & Service level? Please help.

[Anonymous]

Hi @prakash11440278 

Can your dataset be refreshed as planned ? Paginated report is updated according to the update time of the shared dataset .

Best Regard

Community Support Team _ Ailsa Tao

[Samarth_18]

Hi @prakash11440278 ,

If you have created your paginated report using PBI dataset then whenever you refresh your dataset your paginated report automatically get refresh.

Thanks,

Samarth

[prakash11440278]

Hi @Samarth_18 ,

Thanks for your reply. 

I am using power bi dataset using as a source. I am not able to see the latest data in it, even though my pbi dataset data updated.

[Samarth_18]

Ideally, it should refresh whenever the dataset gets refreshed. You can try to reconfigure the dataset again.

[henryle]

I faced the same issue that the dataset seems to use old data. However, it was the issue with the dataset query itself. For my case, it is because the DB server timezone is behind my timezone (+10), so the today data is not latest if I view it earlier than 10am. I have fixed the issue by indicating the timezone needs to be converted. 

In short, as direct database connection, the paginated report will always query latest data based on the defined SQL query.