Power BI report not reflecting data for current week on successful dataflow and dataset refresh.

[JanhaviSwamy]

Hi,

I have created a powerbi report using SharePoint data. Few visuals display data by week number.

I have set up scheduled dataflow and dataset refresh which runs everyday at 3 hours of interval.

Example : If dataflow refrreshes at 1AM then dataset refreshes at 1.30AM.

On every Monday morning dataflow and dataset refresh successfully but latest week number doesn't appear on report.

On manual refresh, latest week and data gets reflected.

Expected Visual

Actual Result

 Any ideas as to what could be wrong?

[audreygerred]

Have you double checked the filter pane to make sure nothing is being excluded? Also, looked at your fact table and ensured the data for week 31 loaded properly?

[JanhaviSwamy]

Hi audreygerred,

Thank you for the response.

On manual dataset and dataflow refresh, data for latest week gets reflected correctly.

Facing issue wit scheduled refresh.

Thanks,

Janhavi