Forum Discussion

pointer_pbi's avatar
pointer_pbi
Helper I
6 years ago

PowerBi - Source Excel File @ One Drive - Returning zeros on every other Scheduled refresh issue

Hello PBI Community, Hope someone can help me with the issue I'm about to describe. Setup: - PowerBI Desktp Pulling Excel File from OneDrive - Excel file at OneDrive has daily, hour, minute, manu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI pointer_pbi 

 

Can you confirm your scheduled refreshes are all completed and none of them have failed.

Even if everything is right the schedule refresh can fail.

Can you post a screen shot of the refresh schedul from PBI service.

 

If all refresh says complete then...

There is no other explanation other than your source on OneDrive has partial data when you refresh schedule refresh is executed.

 

pointer_pbi's avatar
pointer_pbi
Helper I
6 years ago

Hello Anonymous , thanks for your reply.

Attached is the scheduled refresh, without any fail shown as yours, been there an is because an extra column is added or renamed commonly on my end/experience.

On your last comment, how come at the time it fails to show all data, who does it shows it complete after a manual refresh? this is what I can't conceive in my head.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI pointer_pbi 

    Please share one drive refresh schedule

     

    • pointer_pbi's avatar
      pointer_pbi
      Helper I
      6 years ago

      Hello Anonymous ,

      Everyone of them show as complete, and none has error msg.