Forum Discussion

sedden's avatar
sedden
Microsoft Employee
4 years ago

Scheduled refresh error

Hi Team,   I am seeing the bellow error when the schedule refresh runs. If I download the pbix file and enter the creds locally, it does refresh and I can then republish. Why does a manual refresh ...
Refresh Schedule Error
sedden's avatar
sedden
Microsoft Employee
4 years ago

No, no gateway configured. It does refresh sometimes as seen from the refresh history.

Details Type Start End Status Message

Show
Scheduled3/15/2022, 1:03:09 PM3/15/2022, 2:03:29 PMFailedThere was an error when processing the data in the dataset.
Show
On demand3/15/2022, 11:37:43 AM3/15/2022, 12:42:18 PMFailedThere was an error when processing the data in the dataset.
Show
Scheduled3/15/2022, 6:05:08 AM3/15/2022, 7:03:57 AMFailedThere was an error when processing the data in the dataset.
 On demand3/14/2022, 8:49:48 PM3/14/2022, 9:03:49 PMCompleted 
Show
On demand3/14/2022, 4:18:10 PM3/14/2022, 5:07:44 PMFailedThere was an error when processing the data in the dataset.
Show
Scheduled3/11/2022, 8:06:06 AM3/11/2022, 8:40:38 AMFailedThere was an error when processing the data in the dataset.
Show
Scheduled3/10/2022, 4:05:07 PM3/10/2022, 5:12:43 PMFailedThere was an error when processing the data in the dataset.
Show
Scheduled3/10/2022, 12:24:06 PM3/10/2022, 3:16:43 PMFailedThere was an error when processing the data in the dataset.
 Scheduled3/10/2022, 8:06:10 AM3/10/2022, 9:27:57 AMCompleted 
Show
Scheduled3/9/2022, 4:06:07 PM3/9/2022, 5:27:10 PMFailedThere was an error when processing the data in the dataset.
 On demand3/9/2022, 2:08:10 PM3/9/2022, 2:55:42 PMCompleted 
 On demand3/7/2022, 3:33:22 PM3/7/2022, 4:00:33 PMCompleted 
 On demand3/6/2022, 10:05:23 PM3/6/2022, 10:35:57 PMCompleted
Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
4 years ago

And no information in the log?

 

  • sedden's avatar
    sedden
    Microsoft Employee
    4 years ago

    My View is a bit different, I dont see a download log button and if I click in show it give a timeout message with no indication on the data source responsible.

     

    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User
      4 years ago

      Do you want to try some of my "caveman" troubleshooting methods?


      1. Try refreshing individual tables on Power BI Desktop (not PQ) first to see if all the query runs w/o issue. Right click on table and refresh data.

       

      2. if that works, publish the report to a different workspace and set schedule refresh.

       

      If both 1 and 2 works, the original report in workspace may be corrupted (or some other thing). I dont encounter this often but it has happened before.

      Are you using dataflows? direct-query or anything that is not a direct import?

      What are your data sources ( SQL, sharepoint) ?