Forum Discussion

greenguy2012's avatar
greenguy2012
Advocate I
5 years ago

Excel Workbook refresh fails

Hi there,

 

I have a Excel workbook uploaded to powerbi service (with the "Connect" option) that fails to refresh manually (or scheduled) . 

 

The Excel workbook has a super basic powerquery to 1 small sharepoint csv file. It has one 1 pivot table based on a 1 table powerpivot model. 

 

I try refreshing the workbook manually through the Power BI service and it works one time, but subsequent manual refreshes produce the same generic error after spinning for 20 minutes. I ensured my sharepoint credentials are accurate and connected. Is this functionality not working?

 

Activity ID68eeb0ad-cbb8-4c6a-8e2e-2488e397be88
Request ID7f694889-cee7-31ac-e5d2-78c1b228bc16
Correlation ID95eb9177-ca5e-9311-f48b-8edcfd4b637eTimeThu Jul 01 2021 12:04:09 GMT-0500 (Central Daylight Time)
Service version13.0.16276.70
Client version2106.2.06623-train

 

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi greenguy2012 

     

    What I would do is to rather connect via Power BI Desktop and see if that works. I have found when working with Excel can be very tricky.