Forum Discussion

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Is anyone seeing issues refreshing workbooks in the service?

Came in this morning and all 4 of our workbooks we have in the Power BI service failed to refresh. All use the on-prem enterprise gateway. The workbooks are in Sharepoint, and in different workspaces...
Need Help
  • edhans's avatar
    edhans
    7 years ago

    The Power BI team finally got back to me after acknowledging this was a Power BI service issue and not an Excel issue. It is a known issue, a fix is being worked on, but there is no ETA. 

     

    Possible workaround is:

    • copy the workbook to a non-OneDrive/Sharepoint location.
    • Delete the workbook in the service and on OneDrive/Sharepoint.
    • Copy file back to OneDrive/Sharepoint.
    • Republish.

     

    I'm not fooling with that personally, but if they are critical to your workflow, give it a shot. For me, it is easier to open the workbooks in Excel and refresh/save there as I only have 2 of the 4 published workbooks providing useful data currently. The other projects are dormant right now.

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi edhans ,

How could you get the workbook? From the service to get file with the sharepoint and choose "Connect"?

Based on my test, it could work on my side:

And it seemed not to have to configure gateway? Could you please offer me more information?

 

Regards,

Daniel He

 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago

The workbook is in the service. It has a Power Pivot data model in it and the service refreshes it for me. I have 4 of these in three different workspaces, and they all failed again this morning. The workbooks are in Sharepoint Online (office 365)

 

The data is on an on-prem SQL server, so a gateway is in use.

 

Doing a manual refresh does nothing. The error given is usually what happens if someone has the workbook open when the refresh starts, but no one is in these workbooks at this time, certainly not all 4 at once. Different departments have access to different workspaces. And when that does happen, I just manually fire off a refresh and it works. 

 

This just started Sunday, May 5. And the manual refresh does not work. It says "preparing to refresh" and then the dialog box goes away and nothing happens. It doesn't even show as a failed refresh.

 

No manual refresh attempts are even recorded.

 

  • aeckes's avatar
    aeckes
    Frequent Visitor
    7 years ago

    I am seeing this too.  Just started happening very recently with no changes on my end.  Frustrating how this works and then doesn't so frequently.

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      7 years ago
      aeckes wrote:

      I am seeing this too.  Just started happening very recently with no changes on my end.  Frustrating how this works and then doesn't so frequently.

      Yup. Today, 2 worked, 2 failed. No explanation, and manually refreshing doesn't work.

      • aeckes's avatar
        aeckes
        Frequent Visitor
        7 years ago

        edhans checking in - any luck lately? I am still getting many fails, error message "Workbook updates are in progress" while I am certain this is not the case.