Excel Workbook refresh fails

[greenguy2012]

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

[GilbertQ]

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.

[greenguy2012]

Hi Gilbert, how does this comment help me if my report is in Excel?

[GilbertQ]

Hi @greenguy2012 

It provides you with an alternative solution to your error

[greenguy2012]

Telling me to use powerbi is not an alternative answer. My question is specific to excel refreshes.

Using Powerbi does not solve the problem of a failing excel refresh.